| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
=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
|
|||
|
|||
|
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
|
|||
|
|||
|
=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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
=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
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Linear Mode
