up vote 1 down vote favorite
share [g+] share [fb]

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.

link|improve this question
Can you maybe show a screenshot or something? I'm not sure I'm fully getting this. – slhck Jun 16 '11 at 22:48
How can I send you the screenshot?? – Mikel Jun 16 '11 at 23:16
NOW SHOWING B1(empty) - A1(101)= -101 – Mikel Jun 16 '11 at 23:40
empty-101= -101 I WANT: empty-101=empty or empty-101= 0 Finisht: 110-101=9 – Mikel Jun 16 '11 at 23:43
You know, the button that says "upload image" when you edit your post? – slhck Jun 17 '11 at 8:11
feedback

1 Answer

up vote 0 down vote accepted

This answer disregards the fact that the result is negative, but it will not show you a result if the conditions are not correct.

enter image description here

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:

enter image description here

This is from Numbers 09.

link|improve this answer
Thank you wary much man!!!! I love you!!! I was looking for it a long time! – Mikel Jun 17 '11 at 1:32
FWIW, that is the same formula I would have used in Excel. I'm glad it helped. – Kirk Jun 17 '11 at 1:34
@Mikel Also, please accept Kirk's answer below by clicking the green checkmark if it helped you. – slhck Jun 17 '11 at 8:10
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.