View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mbdbiz mbdbiz is offline
external usenet poster
 
Posts: 1
Default Please help! I need multiple formulas for one cell!


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