If calculation

  • Thread starter Thread starter Sandy
  • Start date Start date
S

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?
 
You're welcome!


Angela said:
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.
Click to expand...
 
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.
 
=MIN(MAX(MIN(A1-72),),30)

Just to be different...

=MEDIAN(0,A1-72,30)

= = = =
Dana DeLouis
 
Does the second MIN achieve anything?

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

alternative:

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