Setting a cell to not go below an X value, or above a Y value

[Snakey]

Hey,

This may be very easy to do, but I just don't have a clue, I've look a
most excel variables and they just seem to choose MIN and MAX fro
columns or tables.

What I want to do is I've got the sum adding up say cells A2 and A3 i
cell A4.

I want cell A4 to never go below 80, or above 200. (Formula in cell A
would be =SUM(A2:A3))

Anyone think they can help

 

[Guest]

=MIN(MAX(A2+A3,80),200)

 

[Guest]

This will work...
=IF(SUM(A2:A3)<80,80,IF(SUM(A2:A3)>200,200,SUM(A2:A3)))