1
How can I make iWork Numbers not show me negative results?
For example: The thing is that in A1 I have number 101 and I am doing -A1 from B1. B1 is empty (because I am waiting for the result) so in C1 (which is the result of the A1/B1 calculation) it is showing me -101.
I dont want to see any result in C1 before I receive the missing result from B1.
Mikel
Posted 2011-06-16T22:41:30.820
Reputation: 13
0
This answer disregards the fact that the result is negative, but it will not show you a result if the conditions are not correct.
For the sake of clarity, if formala in B4 is `=IF(B3="","",B2-B3)
The after shot (when B3 has a value) looks like this:
This is from Numbers 09.
Kirk
Posted 2011-06-16T22:41:30.820
Reputation: 2 182
Thank you wary much man!!!! I love you!!! I was looking for it a long time! – Mikel – 2011-06-17T01:32:42.490
FWIW, that is the same formula I would have used in Excel. I'm glad it helped. – Kirk – 2011-06-17T01:34:27.357
@Mikel Also, please accept Kirk's answer below by clicking the green checkmark if it helped you. – slhck – 2011-06-17T08:10:57.550
Can you maybe show a screenshot or something? I'm not sure I'm fully getting this. – slhck – 2011-06-16T22:48:10.703
How can I send you the screenshot?? – Mikel – 2011-06-16T23:16:01.380
NOW SHOWING B1(empty) - A1(101)= -101 – Mikel – 2011-06-16T23:40:41.610
empty-101= -101 I WANT: empty-101=empty or empty-101= 0 Finisht: 110-101=9 – Mikel – 2011-06-16T23:43:36.133
You know, the button that says "upload image" when you [edit] your post? – slhck – 2011-06-17T08:11:21.433