If calculation
in [Functions]
|
From: Sandy on 27 May 2010 15:53 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?
From: Teethless mama on 27 May 2010 16:20 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? > > >
From: Angela on 27 May 2010 17:26 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? > >
From: Teethless mama on 27 May 2010 17:29 =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? >
From: Dana DeLouis on 27 May 2010 21:35 > =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
|
Next
|
Last
Pages: 1 2 Prev: If statement linking data from one sheet to another Next: Macro to build table |