Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to format an IF function to relay information from one cell to
the other. If I use the value of 0 (zero) in the "true if false" portion of my function, then my SUM function for the row works fine... but I want the cell to be blank if there is no info to relay. However, when I use the "" for blank, then I get the #value figure in my SUM function. The SUM function is from a worksheet which was formatted by someone else, and I cannot change it. Is there a way to change the IF function to perform a cell blank if false, but not to put the #value in my SUM function? Thks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
What function can make cells shift up when they are blank? | Excel Worksheet Functions | |||
If Function: Blank cell and 0 (zero) seem to have same "value" | Excel Worksheet Functions |