Quick Question

[DrJim32]

Hello everyone. I have a short question i really really need answering.

A1 = 350 euro

B1 = 500 euro C1 = B1-A1 (ok i do a simple SUM) but in case 1 variable "Say.... B5 isnt in yet so the box is blank..." How do i
B2 = 450 euro C2 = B2-A1 prevent geting 350euro result in C5?
B3 = 150 euro etc etc...
B4 = 230 euro etc
etc
etc
etc...

In other words... I want when it has numbers in both boxes 500-400 to give me the result 100. but when it has numbers only in 1 box because the 2nd box isnt yet in to give me the result 0. (it counts the empty box as a 0 so it does 500-0=500) and really kills me.

Thank you ALL so very much for the time to read this and reply.
Btw happy new year.

 

[PatOBrien198]

use the IF function....

=IF(B5="", 0, B5 - A1)

 

[frank_AL]

This formula evaluates both cells and will return "0" if either cell = 0
=IF(B1>0,IF(C1>0,B1-C1,0),0)

 

[snjpverma]

You can also use this

=IF(B1*A1,B1-A1,)

 

[DrJim32]

This formula evaluates both cells and will return "0" if either cell = 0
=IF(B1>0,IF(C1>0,B1-C1,0),0)

There are so many ways to thank you sadly.
Thank you so very much.

"thank you all for replying as well"
Much appreciated guys.