=IF(AND(B8<621,B21<3000),"Yes","No")
Regards,
"Chink!" wrote in message
...
Hello
I'm trying to write a formula for the following:
If the value in cell B8 < 621
AND
if the value in cell B21 < 3000
value = YES
if not value = NO
Ive tried various ways to write it but keep getting an error
Can someone please let me know the formula?
many thanks
CH!
|