Help! I need multiple formulas for one cell.

[mbdbiz]

Hello,

I was wondering if anyone can assist me with a formula. This is what
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. I
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.

Bell

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[mbdbiz]

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

Bell

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3