excel formula if less than to show a minimum digit

[Guest]

how to use the "IF formula" so that eg. if the calculation is less than "12"
I would like the cell to show 12 if the answer is more than 12 the result
will roundup, for the later I have the formula I would lioke to combine both

 

[JulieD]

Hi

=IF(your formula<12, 12, your formula)

Cheers
JulieD

how to use the "IF formula" so that eg. if the calculation is less than "12"
I would like the cell to show 12 if the answer is more than 12 the result
will roundup, for the later I have the formula I would lioke to combine

both

 

[Frank Kabel]

Hi
try
=MAX(12,your_formula)