Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If calculation
I am trying to do the following inputting in the same cell,
0 to 72=0 73 - 102 = whatever is input in the cell minus 72 over 102 = 30 ie 62 73 82 93 102 0 1 10 21 30 I have managed most of this with IFs, but not all. Does anyone have any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If calculation
=MIN(MAX(MIN(A1-72),),30)
"Sandy" wrote: I am trying to do the following inputting in the same cell, 0 to 72=0 73 - 102 = whatever is input in the cell minus 72 over 102 = 30 ie 62 73 82 93 102 0 1 10 21 30 I have managed most of this with IFs, but not all. Does anyone have any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If calculation
Does the second MIN achieve anything?
=MIN(MAX(A1-72,0),30) alternative: =IF(A1102,30,(A1-72)*(A172)) "Teethless mama" wrote in message ... =MIN(MAX(MIN(A1-72),),30) "Sandy" wrote: I am trying to do the following inputting in the same cell, 0 to 72=0 73 - 102 = whatever is input in the cell minus 72 over 102 = 30 ie 62 73 82 93 102 0 1 10 21 30 I have managed most of this with IFs, but not all. Does anyone have any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF calculation | Excel Worksheet Functions | |||
Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
calculation | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |