Is this possible???

[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 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, the
add $275, otherwise (or anything else), enter $0 to C20.


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

Bella:

 

[MSweetG222]

Bella -

in cell C20 type:
=VLOOKUP(C19,$G$18:$H$22,2,TRUE)

In column G18:H22 type:

Col G Col H
18 0 0
19 1 75
20 13 175
21 25 275
22 37 0

You can move the above table to any place on worksheet. I think you will
get the idea once it on the worksheet and you see how it works.

Good luck!!