IF OR Function Not Return Correct Result

[ankurd6]

Hi I'm tring to use the following formula to return a blank if B6>5 or there is an error value such as #DIV/0!. However, any cells that contain an error values such as #DIV/0! still show #DIV/0!

=IF(OR(B6>5,ISERROR(B6)),"",B6)

Appreciate your help!

 

[AlphaFrog]

Try this...

=IF(ISERROR(B6),"",IF(B6>5,"",B6))

You have to process the error first.

 

[ankurd6]

That worked perfectly, thank you.