Formula in a cell, keep the answer from going over a certain value
 

I am trying to figure out if there is a way to keep a formula in a cell from
the answer going over a certain value. say for example I want to take a value
in one cell (say it was 140) and times it by 12. That equals 1680. But i dont
want it to apear on the spread sheet more than 1500. but if the cell is 100
and you times it by 12 that equals 1200, and that is ok. Just dont want the
end result ever going over 1500. hopefully that makes sence to some one else,
and they know how to do it! Thank you!!

Formula in a cell, keep the answer from going over a certain value
 

Maybe

=MIN(A1*12,1500)

Mike

"Eric" wrote:

I am trying to figure out if there is a way to keep a formula in a cell from
the answer going over a certain value. say for example I want to take a value
in one cell (say it was 140) and times it by 12. That equals 1680. But i dont
want it to apear on the spread sheet more than 1500. but if the cell is 100
and you times it by 12 that equals 1200, and that is ok. Just dont want the
end result ever going over 1500. hopefully that makes sence to some one else,
and they know how to do it! Thank you!!