IF AND function

[Chink!]

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!

 

[Alan]

=IF(AND(B8<621,B21<3000),"Yes","No")
Regards,

 

[Chink!]

Many thanks

How can I add

if value in cell B8 and/or B21 =0

value =" "

?

CH!

 

[Bob Phillips]

=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!]

thank you very much

CH!

=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!]

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!

 

[Bob Phillips]

=IF(AND(B8=0,B21=0),"",IF(AND(B8<621,B21<3000),"Yes","No"))


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Chink!]

Thanks

CH!

=IF(AND(B8=0,B21=0),"",IF(AND(B8<621,B21<3000),"Yes","No"))


--

HTH

RP
(remove nothere from the email address if mailing direct)