I have a problem that hopefully some of you more technically gifted than myself can help me with.
I have been using the following formula to calculate a percentage figure for some large spreadhseets that I am working on:
=IF(L5=0,"",J5/L5)
For some reason, the formula started giving me #DIV/0 errors. Excel help says use the formula that I am using, which doesn't help much. The divisor in these equations is zero.
Thanks for any help you can give me.
Bob
I have been using the following formula to calculate a percentage figure for some large spreadhseets that I am working on:
=IF(L5=0,"",J5/L5)
For some reason, the formula started giving me #DIV/0 errors. Excel help says use the formula that I am using, which doesn't help much. The divisor in these equations is zero.
Thanks for any help you can give me.
Bob