Excel formula to return minimum amount

[Skumby]

HI Have a spreadhseet to calculate fees and charges at work. One of our fees is $114.00 per square meter, with a minimum rate of $405 per annum.

Is there a formula that can multiply E by F and returns either a minimum amount of $405.00 or an amount that is greater than $405.00.

=E43*F43

 

[kevin9999]

Book1
	E	F	G
42	rate	area	formula
43	$114.00	3.5	$405.00
Sheet1

Cell Formulas
Range	Formula
G43	G43	=MAX(405,E43*F43)

Book1
	E	F	G
42	rate	area	formula
43	$114.00	4	$456.00
Sheet1

Cell Formulas
Range	Formula
G43	G43	=MAX(405,E43*F43)

 

[Skumby]

Fab, thank you so much! I was using MIN and it obviously wasn't working Didn't even think to use MAX.

Have a lovely day and thank you for your time.

 

[kevin9999]

Happy to help, and thanks for the feedback