Help! I need multiple formulas for one cell.

[mbdbiz]

Hello,

I was wondering if anyone can assist me with a formula. This is what I need:

C19 is where you enter the inches
C20 adds the charge

The formula to go into C20 needs to be this:

If the number in C19 is 01" through 12" is entered, add $75. If 13" thorugh 24" is entered, add $175, if 25" through 36" is entered, then add $275, otherwise (or anything else), enter $0 to C20. ((" )inches quote sign does not need to be in this formula)

Is this even possible? .... I would really appreciate your help.

Bella

[CLR]

=LOOKUP(C19,{0,1,13,25,37},{0,75,175,275,0})

Vaya con Dios,
Chuck, CABGx3


"mbdbiz" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I was wondering if anyone can assist me with a formula. This is what I
> need:
>
> C19 is where you enter the inches
> C20 adds the charge
>
> The formula to go into C20 needs to be this:
>
> If in number in Cell C19 is 01" through 12" is entered, add $75. If
> 13" thorugh 24" is entered, add $175, if 25" through 36" is entered,
> then add $275, otherwise (or anything else), enter $0 to C20.
>
>
> I would really appreciate your help.
>
> Bella
>
>
> --
> mbdbiz
> ------------------------------------------------------------------------
> mbdbiz's Profile:
http://www.excelforum.com/member.php...o&userid=37309
> View this thread: http://www.excelforum.com/showthread...hreadid=570178
>

[mbdbiz]

Chuck, you're the bomb!!! Thank you!!!!!!

Bella

[CLR]

Happy to help.........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3


"mbdbiz" <[email protected]> wrote in
message news:[email protected]...
>
> Chuck, you're the bomb!!! Thank you!!!!!!
>
> Bella
>
>
> --
> mbdbiz
> ------------------------------------------------------------------------
> mbdbiz's Profile:
http://www.excelforum.com/member.php...o&userid=37309
> View this thread: http://www.excelforum.com/showthread...hreadid=570178
>