Formula: =+AR23/(AO23*0.25)-1

Where AO23 is 0.



"T. Valko" wrote:

Post the formula that's returning the #DIV/0! error.

Biff

"kaci" wrote in message
...
I tried, but it doesnt work........ is there any other ways to do?

"John Bundy" wrote:

Modify this

=IF(ISERROR(formula),"N/A",formula)
--
-John Northwest11
Please rate when your question is answered to help us and others know
what
is helpful.


"kaci" wrote:

Hello experts

I have a cell which have a formula and shows a percentage of growth.
However, some cells result in #DIV . I would like to have a
conditional
formating which can show "N/A" instead of #DIV in the worksheet. How
can I do
it?

If conditional formating cannot do it, any other ways to do it?

Thanks alot.