Error Trap

Hi,

Easier to trap the error in the formula

=IF(ISERROR(your formula),"",(your formula))

Originally Posted by Farnell

#NUM! within a cell.

I have set up formula but when Input Cell is not yet populated I am presented with #NUM! in the destination cell. I need to apply a Conditional Format ie if cell =#NUM! them = white text.

Can anyone help please.

instead of using CF you can amend your original formula like this

=if(iserror(your_formula),"",(your_formula))