Calculating If function

[Gref]

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>

 

[Sektor]

=IF(C12="NAME",G12+MIN(H12,<i12)*(h12 style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">I12)*0.1,"")</i12)*(h12>

 

[snjpverma]

Try if this works
=IF(C12="NAME",(G12+MIN(H12,I12)) *0.1,"")

 

[Gref]

Not working. Using G12 as $10 H12 as $20 and I12 as $30 result with your formula is $12.00 and should be $3.00

 

[snjpverma]

Not working. Using G12 as $10 H12 as $20 and I12 as $30 result with your formula is $12.00 and should be $3.00

i am getting the return value as 3 with the help of the formula below.
=IF(C12="NAME",(G12+MIN(H12,I12))*0.1,"")

 

[Marcílio_Lobão]

gref, Good evening.

A very good new year to all of you, Gref, Sektor and sanjeev1234.

The sanjeev1234's formula works correctly.

Gref, did you correctly enter the parentheses of the formula?

I hope it helps.