Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .