Hello,

I have this simple formula which populates cell C12 with a value

=(A1*10)-100

I then want to check the resulting value and if it is less then 1200, set
the value of C12 to 1200 anyway. If the result is over 1200 then I want it
to show the result of the formula. Is this possible?

I was hoping just to join the first formula with this one:

=IF(C12<1200,1200,IF(C12>1200,C12))

but it doesn't work!

Thanks again for any help
Tracey