Sum If functions
 

Sorry to do this as i think its a very basic formula its just i dont use them
often..

I need to calculate Z5 - X5 but not if Z5 is blank (or zero). Any help would
be great or where exactly i should look as ive tried a few different formulas
from excel help but theyre not working..

Sum If functions
 

You suject line mentions "sum if functions" but your explanation suggests
otherwise.

I need to calculate Z5 - X5

I take that to mean: Z5 minus X5

If that's what you want try this:

=IF(Z5=0,"",Z5-X5)


--
Biff
Microsoft Excel MVP


"Scott R" wrote in message
...
Sorry to do this as i think its a very basic formula its just i dont use
them
often..

I need to calculate Z5 - X5 but not if Z5 is blank (or zero). Any help
would
be great or where exactly i should look as ive tried a few different
formulas
from excel help but theyre not working..

Sum If functions
 

Hi,
I wasnt totally sure of the function.. I actually need Z5 - X5 but not if Z5
= 0, i think the formula i have says if it does = 0?

"T. Valko" wrote:

You suject line mentions "sum if functions" but your explanation suggests
otherwise.

I need to calculate Z5 - X5

I take that to mean: Z5 minus X5

If that's what you want try this:

=IF(Z5=0,"",Z5-X5)


--
Biff
Microsoft Excel MVP


"Scott R" wrote in message
...
Sorry to do this as i think its a very basic formula its just i dont use
them
often..

I need to calculate Z5 - X5 but not if Z5 is blank (or zero). Any help
would
be great or where exactly i should look as ive tried a few different
formulas
from excel help but theyre not working..

Sum If functions
 

the formula below is correct, translation:
if Z5 = 0 then make the cell blank which you do by using two double
quotation marks. This portion is the 'IF,THEN' part of the function. The
next portion is the ELSE part. It says that if Z5 does not = 0 then perform
the function. all statements starting with IF use the same basic principle
of IF,THEN,ELSE in those three segments in that order. each segment can
contain as many nested IF statements and other functions as necessary.

"Scott R" wrote:

Hi,
I wasnt totally sure of the function.. I actually need Z5 - X5 but not if Z5
= 0, i think the formula i have says if it does = 0?

"T. Valko" wrote:

You suject line mentions "sum if functions" but your explanation suggests
otherwise.

I need to calculate Z5 - X5

I take that to mean: Z5 minus X5

If that's what you want try this:

=IF(Z5=0,"",Z5-X5)


--
Biff
Microsoft Excel MVP


"Scott R" wrote in message
...
Sorry to do this as i think its a very basic formula its just i dont use
them
often..

I need to calculate Z5 - X5 but not if Z5 is blank (or zero). Any help
would
be great or where exactly i should look as ive tried a few different
formulas
from excel help but theyre not working..

Sum If functions
 

Sorry guys, i have it working now.. thanx!! :)

"Rod" wrote:

the formula below is correct, translation:
if Z5 = 0 then make the cell blank which you do by using two double
quotation marks. This portion is the 'IF,THEN' part of the function. The
next portion is the ELSE part. It says that if Z5 does not = 0 then perform
the function. all statements starting with IF use the same basic principle
of IF,THEN,ELSE in those three segments in that order. each segment can
contain as many nested IF statements and other functions as necessary.

"Scott R" wrote:

Hi,
I wasnt totally sure of the function.. I actually need Z5 - X5 but not if Z5
= 0, i think the formula i have says if it does = 0?

"T. Valko" wrote:

You suject line mentions "sum if functions" but your explanation suggests
otherwise.

I need to calculate Z5 - X5

I take that to mean: Z5 minus X5

If that's what you want try this:

=IF(Z5=0,"",Z5-X5)


--
Biff
Microsoft Excel MVP


"Scott R" wrote in message
...
Sorry to do this as i think its a very basic formula its just i dont use
them
often..

I need to calculate Z5 - X5 but not if Z5 is blank (or zero). Any help
would
be great or where exactly i should look as ive tried a few different
formulas
from excel help but theyre not working..