| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help! I need multiple formulas for one cell.
=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 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help! I need multiple formulas for one cell.
Chuck, you're the bomb!!! Thank you!!!!!! Bella -- mbdbiz ------------------------------------------------------------------------ mbdbiz's Profile: http://www.excelforum.com/member.php...o&userid=37309 View this thread: http://www.excelforum.com/showthread...hreadid=570178 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help! I need multiple formulas for one cell.
Happy to help.........thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "mbdbiz" wrote in message ... Chuck, you're the bomb!!! Thank you!!!!!! Bella -- mbdbiz ------------------------------------------------------------------------ mbdbiz's Profile: http://www.excelforum.com/member.php...o&userid=37309 View this thread: http://www.excelforum.com/showthread...hreadid=570178 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
| How do I split a cell into multiple rows/columns? | Excel Discussion (Misc queries) | |||
| Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
| Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Hybrid Mode
