Question

"In Q12 create a formula to determine the minimum amount of E12, F12 and G12, and if E12 is the minimum to display "Actual", if the F12 is the minimum to display "Alt1" and if G12 is the minimum to display "Alt2".

Answer 1

To determine the minimum amount of E12, F12, and G12 and display the corresponding label, use the MIN function in Excel with an IF statement.

Step-by-step explanation:

To determine the minimum amount of E12, F12, and G12, you can use the MIN function in Excel. Here's the formula:

=IF(E12=MIN(E12,G12,F12),"Actual",IF(F12=MIN(E12,G12,F12),"Alt1",IF(G12=MIN(E12,G12,F12),"Alt2","")))

This formula checks if E12 is the minimum, if so, it displays "Actual". If not, it checks if F12 is the minimum, if so, it displays "Alt1". Lastly, if neither E12 nor F12 is the minimum, it checks if G12 is the minimum and displays "Alt2". If none of the conditions are met, it displays an empty cell.