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: