MIN function

[B. Kasal]

Please explain what this statement is saying. It works, I just don't
know how to explain it in plain english.

=IF(MIN($E$10,E11),(E11*F11))

Cell E10 is a number I enter, in this case, 8
Cell E11 is the result of a formula, the return being 8.00
Cell F11 is a currency value, in this case, $10.00

The return I get from the formula is $80.00, which is correct. My
confusion is that, if I change cell E10 to another number, I still get
$80.00 as my end result. What is the MIN statement saying?

Thanks much,
Brianna Kasal

 

[JE McGimpsey]

Please explain what this statement is saying. It works, I just don't
know how to explain it in plain english.

=IF(MIN($E$10,E11),(E11*F11))

Cell E10 is a number I enter, in this case, 8
Cell E11 is the result of a formula, the return being 8.00
Cell F11 is a currency value, in this case, $10.00

The return I get from the formula is $80.00, which is correct. My
confusion is that, if I change cell E10 to another number, I still get
$80.00 as my end result. What is the MIN statement saying?

MIN($E$10,E11) will return the minimum of the values in E10 and E11.

The If statement converts what the MIN() function returns to a boolean
(TRUE/FALSE) value - TRUE for any non-zero value, FALSE for zero. A TRUE
value returns the result of E11*F11. Since there's no False branch in
the IF() statement, FALSE will return FALSE.