limit a cell value

[johnfullerroot]

Hi

Does anyone know how I can limit a cells value to be no more than 2

eg i have a cell that has a fomula in it and the result can be anything from 0 to 400 but I want to limit it so that if the number is higher than 2 it will only display it as 2.

[mangesh_yadav]

modify your existing formula to something like this:
Original formula is
= formula

new formula should be
= if(formula>2,2,formula)

e.g. if formula is
=A1+B1
then it should be
= if(A1+B1>2,2,A1+B1)

- Mangesh

[johnfullerroot]

Thanks a lot!

My formula was vastly more complex than that but amizingly it has worked!!!

Thanks again :D