Colum A - Colum C

[agoodson56]

I am trying to get cell 1E to subtract 1C from 1A but if 1C is blank I would like 1E to be blank or show 0.0

 

[njimack]

=if(c1<>"",c1-a1,"")

 

[MrKowz]

Try:

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

or

=IF(C1="","",A1-C1)

 

[poolhall]

=if(c1="","",a1-c1)

 

[JackDanIce]

In cell E1 try:

=IF(OR(ISBLANK(C1),C1=""),"",A1-C1

Change the "" to 0 and then change the format of the cell to show numbers with 1 decimal place - if you rather it show 0.0 instead of blank.

FYI - as a rule you refer to cells by letter first, then number. That is also how formuale reference inputs when you type them into cells

 

[agoodson56]

Thanks that worked great!