Can you get around the 7max IF function?

S

Seti

Here is my current formula:

=IF(B41<29,"$.03",IF(B41<=34,"$.03",IF(B41<=39,"$.06",IF(B41<=44,"$.09",IF(B41<=49,"$.15",IF(B41<=54,"$.26",IF(B41<=59,"$.42",IF(B41<=64,"$.56"))))))))

The formula is actually 8 and it is allowing it, but anything after
that it wont. I need to add 3 more...is there a way to do this. I tried
a few suggestions in another thread but it wasnt working.

Thanks!
 
A

Arvi Laanemets

Hi

=CHOOSE(MATCH(B41,{0;30;35;40;45;50;55;60;65;70;75;80},1),"$3","$3","$6","$9","$15","$26","$42","$56","9th
value","10th value","11th value","overflow")
 
J

JE McGimpsey

One way:

=CHOOSE(MATCH(B41,{9E+307,64,59,54,49,44,39,34},-1), "Too high",
0.56, 0.4, 0.26, 0.15, 0.09, 0.06, 0.03)
 
B

Bob Phillips

=LOOKUP(B41,{0,30,35,40,45,50,55,60,65},{"$.03","$.03","$.06","$.09","$.15",
"$.26","$.42","$.56"})

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top