Conditional Formating

[Guest]

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.

 

[Guest]

Modify this

=IF(ISERROR(formula),"N/A",formula)

 

[Guest]

I tried, but it doesnt work........ is there any other ways to do?

 

[T. Valko]

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

Biff

 

[T. Valko]

Try this:

=IF(AO23=0,"N/A",AR23/(AO23*0.25)-1)

Biff

 

[David Biddulph]

In what way does =IF(ISERROR(AR23/(AO23*0.25)-1),"N/A",AR23/(AO23*0.25)-1)
not work?
What symptoms are you seeing?