Complicated Match Formula with conditions

[kadayadi]

Hello Dear Friends,

Please refer the attached worksheet and I am pulling my hair out thinking of a formula which when matches the given % should give out the required conditions.

Any help will be greatly appreciated

Excel 2010

[sktneer]

May be this........

Please Login or Register  to view this content.

and then drag to M12.

[benishiryo]

hi joseph. 1 other way:
=IF(B10>2,(2*B6-B6)*10+0.1*B6*5,IF(B10>1,(B7-B6)*10+0.1*B6*5,IF(B10>=0.9,(B7-0.9*B6)*5,0)))

B12 is supposed to be 0? 900 - 90% * 1000 = 0

and for this part:

PLUS ((Row 6 value for the month)-(90% of Row 6 value for the month))* $5

row 6 value - 90% of row 6 value is simply 10% of row 6 value

[kadayadi]

Thanks benishriyo and sktneer