View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mbdbiz mbdbiz is offline
external usenet poster
 
Posts: 1
Default 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 in number in Cell 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.


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=570178