ISERROR formula within an OR statement

[Carl Clements]

Hi,

Is it possible to include an ISERROR formula within an OR statement?

If my record is either #N/A or 0, I want to return a message ,"Please enter shares".

I was expecting the below to work, however it failed with the message, 'your formual contains an error'

Can anybody suggest an alternative?

=IF(or(ISERROR(F20=TRUE,F20=0,"Please enter shares","")

Thanks,
Carl

 

[VoG]

Try

=IF(OR(ISERROR(F20),F20=0),"Please enter shares","")

 

[Andrew Poulsom]

Is it?

=IF(ISERROR(OR(F20=TRUE,F20=0)),"","Please enter shares")

 

[Richard Schollar]

Hi Carl

Try:

=IF(COUNTIF(F20,"#N/A")+COUNTIF(F20,0),"Please enter shares","")

 

[njimack]

Post deleted.