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.