how do I put to IF's into one formula?
B Bob Phillips Nov 24, 2005 #2 =SUMPRODUCT(--(rng1="string_value"),--(rng2=numeric_value2), rng_to_sum) -- HTH RP (remove nothere from the email address if mailing direct)
=SUMPRODUCT(--(rng1="string_value"),--(rng2=numeric_value2), rng_to_sum) -- HTH RP (remove nothere from the email address if mailing direct)
R Ron Coderre Nov 24, 2005 #3 Without more specific information, here are the basic structures: =IF(test1,IF(test2,test2_true,test2_false),test1_false) or =IF(test1,test1_true,IF(test2,test2_true,test2_false)) Do either of those help? *********** Regards, Ron
Without more specific information, here are the basic structures: =IF(test1,IF(test2,test2_true,test2_false),test1_false) or =IF(test1,test1_true,IF(test2,test2_true,test2_false)) Do either of those help? *********** Regards, Ron
