[newbie] if statement
Hi,
The syntax for AND is:
AND(Condition1, Condition 2, Condition n)
Try this syntax:
=IF(AND(F5H5, UPPER(C7)="YES", C9/C10H9),"Yes","No")
Note that if C10 is blank, you'll get a #DIV/0! (divide by zero) error.
Regards - Dave.
"Jon" wrote:
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?
|