Spreadsheet Expert please

[2blue4u]

I'm working in Numbers but I can also converse in Excel.

I'm trying to find a simple and elegant solution to this. I need a formula that returns the result of a simple calculation OR a set figure whichever is higher.

For example. Set minimum figure is 165.

12 * 15 results in 180

&

8 * 12 results in 165

Posting question to prevent further head scratching. Please help.

 

[RacingSnake]

If 12 is in "A1" and 15 is in "B1"...
then "C1" should be "=IF((A1*B1)<165,165,(A1*B1))" should do it.

 

[Furtim]

=max(8*12,165)

Obviously you can replace 8*12 or even 165 with calcs or cell references.

 

[RacingSnake]

=max(8*12,165)

Yeah, just replace 8 & 12 with A1 and B1 (for example).... better than my solution

 

[2blue4u]

Brilliant! Thank you guys. Have a