View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Jon is offline
external usenet poster
 
Posts: 183
Default [newbie] if statement

I'm trying to include a conditional however, I'm getting a sort of a syntax
error:

=if((F5H5) AND (UPPER(C7) = "YES") AND (C9/C10 H9), "Yes", "No")

F5 0.80
H5 0.75
C7 Yes
C9 50000
C10 45000 C9/C10 = 1.11.
H9 0.90

Any ideas?