ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   IF AND function (https://www.excelbanter.com/excel-worksheet-functions/7102-if-function.html)

Chink!

IF AND function
 
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!" 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!





Chink!

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!







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!" 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!









Chink!

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!











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!



"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!













Bob Phillips

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















Chink!

Thanks

CH!
"Bob Phillips" wrote in message
...
=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!


















All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com