If calculation

[Sandy]

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?

 

[Teethless mama]

You're welcome!

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.

 

[Angela]

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]

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

 

[Dana DeLouis]

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

Just to be different...

=MEDIAN(0,A1-72,30)

= = = =
Dana DeLouis

 

[Steve Dunn]

Does the second MIN achieve anything?

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

alternative:

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