Differenec formula: Dnt need '0' as a result;Rather have a blank c

  • Thread starter Thread starter Rum
  • Start date Start date
R

Rum

Hi,

I have an excel sheet with data in columns A & B on TAB 1 and I am trying to
have the DIFFERENCE of TAB 1-Cell A1 & B1 in TAB 2-Cell A1.

My Cells A1 & B1 of TAB1 are empty (have nothing in them) and when I apply
the formula I get "0" as result in Cell A1-TAB 2.

Is there a way to NOT get '0' in the result cell with the formula still
being in there even when your data cells are empty?

Please help.

Thanks
Regards
Rum
 
Start your formulae with an IF statement, to check whether Cell A in Tab 1
has a value. =IF(TAB1!A1="","",TAB1!A1-TAB1!B1)
--
HTH

Kassie

Replace xxx with hotmail
 
Rum said:
Is there a way to NOT get '0' in the result cell with the formula
still being in there even when your data cells are empty?
Click to expand...

=if(and(tab1!A1="", tab1!B1=""), "", tab1!A1 - tab1!B1)

Alternatively:

=if(countif(tab1!A1:B1,"")=2, "", tab1!A1 - tab1!B1)

Caveat: In both cases, it would be prudent to write n(tab1!A1) -
n(tab1!B1), just in case either A1 or B1 might be "", not truly empty.


----- original message -----
 
=IF(Sheet1!A1-Sheet1!B1=0,"",Sheet1!A1-Sheet1!B1)

Or if you want to see a zero when the difference evaluates to a real zero

=IF(AND(Sheet1!A1="",(Sheet1!B1="")),"",Sheet1!A1-Sheet1!B1)


Gord Dibben MS Excel MVP
 
Back
Top