Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 1 down vote favorite

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.

share|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

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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