Please 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.

Btw...((" )inches quote sign does not need to be in this formula)

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

 

[Guest]

=IF(C19<=0,"Number is cero or smaller",IF(C19<=12,