Subtraction Formula

  • Thread starter Thread starter Angel79
  • Start date Start date
A

Angel79

Hi,

Was wondering if it was possible to have a cell subtract from anothe
cell but if one of the cells are empty for it to show 0.

Example of what I want:

A1: 100 (main number)
A2: 40 (new number)
A3: 60 (A1-A2)
A4: (new number to be later added)
A5: 0 (A3-A4) using this formula this cell will show 60...but A
dosen't have a number entered yet so I want it to show a 0 instead. I
this possible?


Thanks in advance,
Ange
 
Good job of laying out the question..

Ditto - makes life a WHOLE LOT easier for folks in here!!! :-)
 
Thanks you guys! Both of those options worked perfectly!!

Sorry I didnt get back sooner saying so but everythings been a bi
hectic!

Thanks again,
Ange
 
Back
Top