View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
luvnrocs luvnrocs is offline
external usenet poster
 
Posts: 5
Default OR function problem

I'm trying o figure out why this formula isn't working as expected.

I need to check in a column to see if any cells have the number zero
or #NA. If either condition is true, OR should return "True" and then
make the destination cell blank. If neither condition is met then OR
returns "False" and the value from F11 is copied to G11.

This formula is in cell G11:

=IF(OR(ISNA(F11),F11=0),"",F11)