=IF(AND(B8=0,B21=0),"",IF(AND(B8<621,B21<3000),"Ye s","No"))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Chink!" wrote in message
...
OK I think I asked the wrong question
What is the formula for:
If B8 and B21 = 0 result = " "
If B21<3000 result = "yes"
AND
If B8<621 result = "yes"
otherwise result ="no"
thanks for your patience
CH!
"Chink!" wrote in message
...
thank you very much
CH!
"Bob Phillips" wrote in message
...
=IF(OR(B8=0,B21=0),"",IF(AND(B8<621,B21<3000),"Yes ","No"))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Chink!" wrote in message
...
Many thanks
How can I add
if value in cell B8 and/or B21 =0
value =" "
?
CH!
"Alan" wrote in message
...
=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!
|