Can you get around the 7max IF function?
 

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!

Can you get around the 7max IF function?
 

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")


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )




"Seti" wrote in message
...

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!




--
Seti

Can you get around the 7max IF function?
 

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)


In article ,
Seti wrote:

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!

Can you get around the 7max IF function?
 

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

"Seti" wrote in message
...

Here is my current formula:


=IF(B41<29,"$.03",IF(B41<=34,"$.03",IF(B41<=39,"$. 06",IF(B41<=44,"$.09",IF(B
41<=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!




--
Seti

Thank you! That worked great! I appreciate it.