What IF - formula question
except I need the G43=0 to include + & - results. I only need #div/0! to be
shown as nothing.
--
Gene
"Pete_UK" wrote:
I think you mean something like:
=IF(G43=0,"",H43/G43)
Hope this helps.
Pete
Gene wrote:
I need help with an IF formula question. My cell has a formula in it
=sum(H43/G43). I want this cell blank ""
If the result is not a percentage (the cell has been formatted to be a %).
When I drag the formula to many other cells some of them are #DIV/O! and I
want those cells to be blank.
I can't figure out how to do this. Thanks for your time and help!
--
Gene
|