Prev: If statement linking data from one sheet to another
Next: Macro to build table
From: Steve Dunn on 28 May 2010 04:35
Does the second MIN achieve anything?

=MIN(MAX(A1-72,0),30)

alternative:

=IF(A1>102,30,(A1-72)*(A1>72))



"Teethless mama" <Teethlessmama(a)discussions.microsoft.com> wrote in message
news:E8579FC4-B779-4DBF-962D-3DE3CD8DB2EC(a)microsoft.com...
> =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?
>>

First  |  Prev  | 
Pages: 1 2
Prev: If statement linking data from one sheet to another
Next: Macro to build table