Spreadsheet Expert please

2blue4u

2blue4u

Suspended / Banned
Messages
3,769
Name
John
Edit My Images
Yes
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.
 
If 12 is in "A1" and 15 is in "B1"...
then "C1" should be "=IF((A1*B1)<165,165,(A1*B1))" should do it.
 
Last edited:
=max(8*12,165)

Obviously you can replace 8*12 or even 165 with calcs or cell references.
 
You must log in or register to reply here.
Back
Top