=IF(C19<=0,"Number is cero or smaller",IF(C19<=12,
C19+75,IF(C19<=24,C19+175,IF(C19<=36,C19+275,IF(C1 9=37,0)))))
Try the formula above, i think this is what you are looking for...
if not let me know...
If by accident you enter a cero or negative number the cell will display "Number is cero or smaller".
If the number is grated than "36" a "0" will be in your cell.
"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.
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