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 