If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
If calculation
You're welcome!
"Angela" wrote: Thankyou so much!!!!!! This has solved a big problem. Great to have people who know what they are doing help out the inexperienced...Great!! Thanks again. "Teethless mama" wrote: =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
|
|||
|
|||
If calculation
Thankyou so much!!!!!! This has solved a big problem. Great to have people
who know what they are doing help out the inexperienced...Great!! Thanks again. "Teethless mama" wrote: =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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
If calculation
=MIN(MAX(MIN(A1-72),),30)
Just to be different... =MEDIAN(0,A1-72,30) = = = = Dana DeLouis On 5/27/2010 5:26 PM, Angela wrote: Thankyou so much!!!!!! This has solved a big problem. Great to have people who know what they are doing help out the inexperienced...Great!! Thanks again. "Teethless mama" wrote: =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? -- = = = = = = = HTH :) Dana DeLouis |
#6
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|