Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ok more on sumproduct
Hi all,
OK I have the sumproduct working well, which is great....but how do I set it up so that if the result is going to be 0 the cell appears blank....I have bashed my brains with IF statements (the way I normally do this) but I don't think it will work. Any ideas? Danny |
#2
|
|||
|
|||
Hi
IF(SUMPRODUCT(....)=0,"",SUMPRODUCT(...)) -- Regards Frank Kabel Frankfurt, Germany "Danny J" schrieb im Newsbeitrag ... Hi all, OK I have the sumproduct working well, which is great....but how do I set it up so that if the result is going to be 0 the cell appears blank....I have bashed my brains with IF statements (the way I normally do this) but I don't think it will work. Any ideas? Danny |
#3
|
|||
|
|||
So obvious when it is shown...thank you again.
Danny "Frank Kabel" wrote in message ... Hi IF(SUMPRODUCT(....)=0,"",SUMPRODUCT(...)) -- Regards Frank Kabel Frankfurt, Germany "Danny J" schrieb im Newsbeitrag ... Hi all, OK I have the sumproduct working well, which is great....but how do I set it up so that if the result is going to be 0 the cell appears blank....I have bashed my brains with IF statements (the way I normally do this) but I don't think it will work. Any ideas? Danny |
#4
|
|||
|
|||
It's hard to tell without seeing your formula, but one would be
=IF(your_formula=0,"",your_formula) Regards, Peo Sjoblom "Danny J" wrote: Hi all, OK I have the sumproduct working well, which is great....but how do I set it up so that if the result is going to be 0 the cell appears blank....I have bashed my brains with IF statements (the way I normally do this) but I don't think it will work. Any ideas? Danny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions | |||
Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions | |||
SUMPRODUCT using offset from ROW if X marks the spot | Excel Worksheet Functions |