Can you get around the 7max IF function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Seti - 24 Aug 2006 03:27 GMT

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!

Signature

Seti

Reply to this Message

Arvi Laanemets - 24 Aug 2006 09:52 GMT

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

Signature

Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

> Here is my current formula:
>
[quoted text clipped - 5 lines]
>
> Thanks!

Reply to this Message

JE McGimpsey - 24 Aug 2006 09:54 GMT

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)

> Here is my current formula:
>
[quoted text clipped - 6 lines]
>
> Thanks!

Reply to this Message

Bob Phillips - 24 Aug 2006 09:58 GMT

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

Signature

HTH

Bob Phillips

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

> 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!

Reply to this Message