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

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

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

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

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

"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

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

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

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

=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