How to not get '0' or '#DIV/0!' in a cell with a percentage formul
Hi,
Try
=IF(B1=0,"",A1/B1)
or the shorter
=IF(B1,A1/B1,"")
And regarding the second question: You need to protect the worksheet -
Select all the cells you want to be unlocked and choose Format, Cells,
Protection, and uncheck Locked. Next choose Tools, Protection, Protect
Sheet...
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Rum" wrote:
I am trying to get rid of the "zeros" and "#DIV/0!" in a cell with a cell a
percentage formula.
Example:
Column A2 = Numerator
Column B2 = Denominator
Then for % formula I do the following in column A1:
=A2/B2
And this gives me a the cell A1 with percent formula but if the cells A2 and
B2 are blank then it gives "#DIV/0!".
Can we design this formula in such a way that the target cell (A1) remains
empty but still has the formula?
Also, how can I lock the formula cells so that no one can change it?
Please help.
Thanks
|