Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying formulas from cell to cell to cell to....... Tom Hardy Excel Discussion (Misc queries) 3 June 15th 06 03:29 PM
How do I split a cell into multiple rows/columns? SKA Excel Discussion (Misc queries) 1 January 18th 06 01:04 AM
Dates of a Day for a month & year cell formulas mikeburg Excel Discussion (Misc queries) 2 December 29th 05 11:14 PM
Problem with formulas changing cell reference janicesweet Excel Discussion (Misc queries) 1 August 2nd 05 06:23 PM
Formula to return cell contents based on multiple conditions Bill Excel Worksheet Functions 3 January 19th 05 10:59 AM


All times are GMT +1. The time now is 03:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"