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:

--
mbdbi
-----------------------------------------------------------------------
mbdbiz's Profile: http://www.excelforum.com/member.php...fo&userid=3730
View this thread: http://www.excelforum.com/showthread.php?threadid=57018

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

--
Thx
MSweetG222



"mbdbiz" wrote:


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.


Is this even possible?.... 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=570183