How to establish a maximum and minimum value to a cell

[jvega]

Hi,

I was wondering how would I go about establishing a maximum and minimum
value to a cell?

Ex.: Cell B30=(B3-B23)/1000

I want B30 to range only from -.5 to .5.

So if B30=-1, I want it to turn into -.5, and if it equals 1, I want it to
turn into .5

Any help would be appreciated.

Thanks,
Josh

 

[Teethless mama]

=MAX(MIN((B3-B23)/1000,0.5),-0.5)

 

[jvega]

Awesome, thank you

=MAX(MIN((B3-B23)/1000,0.5),-0.5)

 

[David Biddulph]

=MEDIAN(-0.5,(B3-B23)/1000,0.5)