=LOOKUP(C19,{0,1,13,25,37},{0,75,175,275,0})
Vaya con Dios,
Chuck, CABGx3
"mbdbiz" wrote in
message ...
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:)
--
mbdbiz
------------------------------------------------------------------------
mbdbiz's Profile:
http://www.excelforum.com/member.php...o&userid=37309
View this thread: http://www.excelforum.com/showthread...hreadid=570179