how do I use a % range for instance if f13 is 25-75% in a formula
B Bob Phillips Apr 20, 2006 #2 =IF(AND(F13>=25%,F13<=75%),"yes","no") -- HTH Bob Phillips (remove nothere from email address if mailing direct)
=IF(AND(F13>=25%,F13<=75%),"yes","no") -- HTH Bob Phillips (remove nothere from email address if mailing direct)
L las Apr 20, 2006 #3 Bob I have been working on this for hours...thank you for you assistance it worked! las
