Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help required!
I am trying to set a formula to achieve the following and would appreciate
any assistance: I have a number in a cell which if less than 7 should show 7 but if greater than 7 and less than 25 should display itself and greater than 25 should show 25. i.e 3.4 shows 7; 9.5 shows 9.5; 28 shows 25 i can do any two of these but not all 3. Please help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help required!
The following if statement should do the trick. Substitute your cell witht
the value for the expamples cell A1: =IF(A1<=7,7,IF(AND(A17,A1<25),A1,25)) -- Kevin Backmann "MarkW1307" wrote: I am trying to set a formula to achieve the following and would appreciate any assistance: I have a number in a cell which if less than 7 should show 7 but if greater than 7 and less than 25 should display itself and greater than 25 should show 25. i.e 3.4 shows 7; 9.5 shows 9.5; 28 shows 25 i can do any two of these but not all 3. Please help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help required!
Just another option:
=MAX(MIN(A1,25),7) -- HTH :) Dana DeLouis "MarkW1307" wrote in message ... I am trying to set a formula to achieve the following and would appreciate any assistance: I have a number in a cell which if less than 7 should show 7 but if greater than 7 and less than 25 should display itself and greater than 25 should show 25. i.e 3.4 shows 7; 9.5 shows 9.5; 28 shows 25 i can do any two of these but not all 3. Please help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help required!
Excellent, worked perfectly.
Thanks Kevin "Kevin B" wrote: The following if statement should do the trick. Substitute your cell witht the value for the expamples cell A1: =IF(A1<=7,7,IF(AND(A17,A1<25),A1,25)) -- Kevin Backmann "MarkW1307" wrote: I am trying to set a formula to achieve the following and would appreciate any assistance: I have a number in a cell which if less than 7 should show 7 but if greater than 7 and less than 25 should display itself and greater than 25 should show 25. i.e 3.4 shows 7; 9.5 shows 9.5; 28 shows 25 i can do any two of these but not all 3. Please help! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help required!
=MEDIAN(7,A1,25)
-- David Biddulph "MarkW1307" wrote in message ... I am trying to set a formula to achieve the following and would appreciate any assistance: I have a number in a cell which if less than 7 should show 7 but if greater than 7 and less than 25 should display itself and greater than 25 should show 25. i.e 3.4 shows 7; 9.5 shows 9.5; 28 shows 25 i can do any two of these but not all 3. Please help! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help required!
Why test for A17, when you had previously tested for A1<=7 ?
-- David Biddulph "Kevin B" wrote in message ... The following if statement should do the trick. Substitute your cell witht the value for the expamples cell A1: =IF(A1<=7,7,IF(AND(A17,A1<25),A1,25)) -- Kevin Backmann "MarkW1307" wrote: I am trying to set a formula to achieve the following and would appreciate any assistance: I have a number in a cell which if less than 7 should show 7 but if greater than 7 and less than 25 should display itself and greater than 25 should show 25. i.e 3.4 shows 7; 9.5 shows 9.5; 28 shows 25 i can do any two of these but not all 3. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula required | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula required | Excel Discussion (Misc queries) | |||
Formula Required | Excel Worksheet Functions | |||
Help Required With IF AND Formula | Excel Worksheet Functions |