Remember Me?

 Chink! Posts: n/a 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 Posts: n/a =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! Posts: n/a Many thanks

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 Posts: n/a =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

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! Posts: n/a 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

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! Posts: n/a 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"

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

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 Posts: n/a =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"

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

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! Posts: n/a 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"

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

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!

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Nate Oliver Excel Discussion (Misc queries) 0 December 14th 04 05:57 PM PE Excel Discussion (Misc queries) 2 December 7th 04 02:00 AM R. Hale Excel Worksheet Functions 3 November 25th 04 08:07 AM thinkingfield Excel Worksheet Functions 1 November 8th 04 05:01 PM Simon Lloyd Excel Worksheet Functions 0 November 8th 04 04:13 PM

All times are GMT +1. The time now is 10:49 PM. Copyright ©2004-2019 ExcelBanter.