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

  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Please 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 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



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

=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


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
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 02:36 AM
How do I set up multiple logical conditions on one result cell Ring eye Excel Worksheet Functions 1 January 12th 06 08:31 PM
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 08:04 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"