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" wrote:

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

"Rum" wrote:
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?

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

"Rum" wrote in message
...
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

Try this:

=IF(COUNT(Sheet1!A1:B1)=2,Sheet1!A1-Sheet1!B1,"")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Rum" wrote in message
...
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

=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

On Tue, 28 Jul 2009 12:03:01 -0700, Rum
wrote:

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