Another Formula Question.
Posted by Jo on January 11, 2002 9:37 AM
I should have figured this out by now. Sorry.
I have a formula to figure out the percentage. It's
=C7/C8
However, there are days when there isn't any data to divide, on these days, I would like the cell to stay blank instead of showing the DIV#0 error. How can I do this?
Posted by Aladin Akyurek on January 11, 2002 9:56 AM
=IF(C8,C7/C8,"") or...
=IF(C8,C7/C8,0)
and custom format the cell of this formula as: [=0]"";General
Aladin
=====
Posted by Jo on January 11, 2002 10:04 AM
Re: =IF(C8,C7/C8,
Ok, I've got this formula, but can't get the =0 in correctly. How do I enter it in so it shows a blank cell if 0? =IF(G37,G31/G37,0)
Posted by Aladin Akyurek on January 11, 2002 10:11 AM
Re: =IF(C8,C7/C8,
> Ok, I've got this formula, but can't get the =0 in correctly. How do I enter it in so it shows a blank cell if 0? =IF(G37,G31/G37,0)
Jo --
Activate the cell that houses =IF(G37,G31/G37,0);
Activate Format|Cells;
On the Number tab, choose "Custom" for Category and enter in the box for "Type:"
[=0]"";General
instead of what you see there.
Aladin
=========
Posted by jason on January 11, 2002 10:37 AM
Re: =IF(C8,C7/C8,
use the following:
=IF(or(G37=0,g37=""),"",G31/G37)
