Error checking

[bluegold]

Hi guys,

The following excel code works as desired but if there is an error in the other columns it spits out "#N/A" instead of TRUE / FALSE.
Is there a way for it just to display FALSE instead?

=IF(AND($D288>1.99,$D288<3.01,$I288<"",$AP288="",$A288<=TODAY()),IF($I288<-1,TRUE,IF($I288>1,TRUE,IF(AND($I288>0.05,$I288<1),TRUE))))

 

[Tetra201]

Try:

=IFERROR(IF(AND($D288>1.99,$D288<3.01,$I288<"",$AP288="",$A288<=TODAY()),IF($I288<-1,TRUE,IF($I288>1,TRUE,IF(AND($I288>0.05,$I288<1),TRUE)))),FALSE)

 

[bluegold]

Thanks Tetra

 

[Tetra201]

You are welcome.