#1   Report Post  
Old November 25th 04, 10:15 PM
Chink!
 
Posts: n/a
Default 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!



  #2   Report Post  
Old November 25th 04, 11:05 PM
Alan
 
Posts: n/a
Default

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




  #3   Report Post  
Old November 26th 04, 09:15 AM
Chink!
 
Posts: n/a
Default

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!






  #4   Report Post  
Old November 26th 04, 10:08 AM
Bob Phillips
 
Posts: n/a
Default

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








  #5   Report Post  
Old November 26th 04, 07:28 PM
Chink!
 
Posts: n/a
Default

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!












  #6   Report Post  
Old November 26th 04, 07:46 PM
Chink!
 
Posts: n/a
Default

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!












  #7   Report Post  
Old November 26th 04, 09:07 PM
Bob Phillips
 
Posts: n/a
Default

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














  #8   Report Post  
Old November 27th 04, 10:28 AM
Chink!
 
Posts: n/a
Default

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!


















Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function in XL or in VBA for XL that pulls numeric digits from a t Nate Oliver Excel Discussion (Misc queries) 0 December 14th 04 05:57 PM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 02:00 AM
Find a Function to use accross different worksheets R. Hale Excel Worksheet Functions 3 November 25th 04 08:07 AM
change function variable prompts?? thinkingfield Excel Worksheet Functions 1 November 8th 04 05:01 PM
Counting Function Dilemma Simon Lloyd Excel Worksheet Functions 0 November 8th 04 04:13 PM


All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017