Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
XL2003 FILTER FUNCTIONS VS. XL2007 FILTER FUNCTIONS | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |