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