G
Guest
I'm using an "IF" statement to return a blank if a value is less than the
absolute value of 100. Downstream, I'm doing a sum minus some of the cells
that have the IF statement in it. For cells that return a blank, the
downstream formula goes to error. I could set the IF statement to return a
zero, but that messes up my preferred formatting.
I can live with rewriting the IF statement to return a zero, not a blank, if
I can get the standard comma format to show up, but formatting the cell does
not seem to work.
Another way to handle it would be to get the formula to not return an error,
but that is also beyond my skills.
Any help?
Sample formula IF statement from my spreadsheet:
=IF((ABS('P&L Synopsis'!M57)<100),"",+'P&L Synopsis'!M57)
Sample formula that gets error:
='Corp Supp'!S117/1000-AG51-AG53-AG55-AG49
Error returned is #VALUE!
absolute value of 100. Downstream, I'm doing a sum minus some of the cells
that have the IF statement in it. For cells that return a blank, the
downstream formula goes to error. I could set the IF statement to return a
zero, but that messes up my preferred formatting.
I can live with rewriting the IF statement to return a zero, not a blank, if
I can get the standard comma format to show up, but formatting the cell does
not seem to work.
Another way to handle it would be to get the formula to not return an error,
but that is also beyond my skills.
Any help?
Sample formula IF statement from my spreadsheet:
=IF((ABS('P&L Synopsis'!M57)<100),"",+'P&L Synopsis'!M57)
Sample formula that gets error:
='Corp Supp'!S117/1000-AG51-AG53-AG55-AG49
Error returned is #VALUE!