Trying to get the following result.

I want to add one cell G12 to the results of an IF function and then multiply the result by 10%. I want the IF function to use the lesser of two cells then add that figure to G12 and multiply by 10%. This is what I tried, but it didn't work. (Also, the first IF function is to recognize the name in C12)

=IF(C12="NAME",SUM(G12+IF((H12<i12)*(h12>I12),H12,I12))*0.1,"")

As an example:

If C12 = NAME AND G12 = $10.00 and H12=$20.00 and I12 =$30.00 the result would be $30.00 X 10% for a result of $3.00

OR

If C12 = NAME AND G12 = $10.00 and H12=$40.00 and I12 = $10.00 the result would be $20.00 X 10% for a result of $2.00

</i12)*(h12>

I want to add one cell G12 to the results of an IF function and then multiply the result by 10%. I want the IF function to use the lesser of two cells then add that figure to G12 and multiply by 10%. This is what I tried, but it didn't work. (Also, the first IF function is to recognize the name in C12)

=IF(C12="NAME",SUM(G12+IF((H12<i12)*(h12>I12),H12,I12))*0.1,"")

As an example:

If C12 = NAME AND G12 = $10.00 and H12=$20.00 and I12 =$30.00 the result would be $30.00 X 10% for a result of $3.00

OR

If C12 = NAME AND G12 = $10.00 and H12=$40.00 and I12 = $10.00 the result would be $20.00 X 10% for a result of $2.00

</i12)*(h12>

Last edited: