Community Discussions
Explore the latest discussions and community conversations related to this domain.
Numbers: How can I make zeroes show empt… - Apple Community
Main Post: Numbers: How can I make zeroes show empt... - Apple Community
Show xp drops for 0 hits and when you're 200m xp in a skill.
Main Post:
It would be neat if we could get xp drops when we splash or hit 0's. You can normally keep a rhythm without them but it would help a lot and hopefully wouldn't be much work.
Also, people with 200m xp don't get xp drops. It would help them to get xp drops even if they don't get xp (it's useful in combat situations).
Thank you for watching. Like, comment, and subscribe.
Top Comment: Support, would stop people from being at a disadvantage whilst pking if they have a 200m.
Going to a Kabuki show with 0 Japanese language skill : japanlife
Main Post: Going to a Kabuki show with 0 Japanese language skill : japanlife
Cyclone laser weapon not working, show 0 shots count.
Main Post:
Hi, I've upgraded my MT and TR Cyclones with a laser CF-117 Bulldog but both, when powered up show 0 a shot counts.
Ofc I've done several power cycle outside armistice zone and everything else like changing power mapping but nothing works on both two vehicles.
Did I've missed something, it's a known issue or else? Thanks.
Top Comment:
Energy weapons don’t currently work on the Cyclone vehicles, though ballistic weapons do. My assumption is that CIG forgot to implement the capacitor for the vehicle. I haven’t tested any other ground vehicles to see if they suffer the same issue.
Show blank cell instead of 0
Main Post:
I have this simple formula to convert from miles to km round(prop("Mileage") * 1609.34 / 1000) / 1
but the problem is that when a cell in the 'Mileage' column is blank, the formula obviously returns a 0. I'd like to show a blank field instead. I have read to use toNumber("") but I can't find a syntax that works. I am very new to Notion and would appreciate any help!
Top Comment:
You'll have to first check to see if Mileage is empty.
if(empty(prop("Mileage")), toNumber(""), round(prop("Mileage") * 1609.34 / 1000))How to show ps controller icons on yakuza 0 instead of xbox controller icons on pc/steam version of yakuza 0 without mods?
Main Post:
I use a USB xbox 360 controller for the steam games I own and I'm not used to the controls of xbox controllers for tempo/rhythm games (esp the sidequests), since I was a ps owner before. Is it possible to display the ps controller icons without any modifications?
I've tried changing the steam input per Game setting to forced off, but it doesn't seem to work.
Top Comment: You can try this guide. I haven't done it myself yet as installing PSnow might start their trial. Edit: I missed the part of you using an Xbox controller. The guide I linked to eventually links to another guide, which is about replacing the button prompts.
Show div/0 error as 0
Main Post:
Hi
I'm setting up a sheet at work to check guard clocking percentages and I want to know the total percentage for a month so I used the following
=AVERAGE(C4:AG4)
It returns a #div/0! error when the fields are not populated
I can't just sum C4:AG4 and divide by 31 since that will return an incorrect average in months with less than 31 days
I tried using =IFERROR(AVERAGE(C4:AG4),"0") as suggested on an old forum post, but then it returns Err:501
Any ideas?
Version 6.4.1.2
Windows 10
Format .ods
Top Comment:
Assuming C4 is the first of the month (and therefore will always be the first field filled) you could have =IF(C4>0, AVERAGE(C4:AG4),"0")
Why does this always show 0?
Main Post: Why does this always show 0?
Top Comment:
Because you only look at it right after you respawn.
Linkin Park - v2.0 Emily Armstrong FULL SHOW HD LIVE 9 5 2024 [Live]
Main Post: Linkin Park - v2.0 Emily Armstrong FULL SHOW HD LIVE 9 5 2024 [Live]
Top Comment: Absolute garbage. Her screams sounds soooo bad. Maybe she has blackmail on the rest of the members because there is zero chance she was the best they could find. Serious disrespect to Chester.
Numerical Display Screens to show item count
Main Post: Numerical Display Screens to show item count
Top Comment: With the new Display Screens available in 2.0, I wanted to create a numerical display that could show item count, so here we are! Blueprint string: https://factoriobin.com/post/srewzg The Imgur post has some details on how it works and how to use it, as well as the combinators themselves making use of the new "Description" feature to explain how to use it. The array is expandable too, simply add more screens and pairs of combinators to the left, and wire them up. I'm sure there's a simpler way to do it but my brain is not endowed with many creases when it comes to circuits.