Complicated Match Formula with conditions

[Excel Dumbo]

Hello Dear Friends,

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

Any help will be greatly appreciated

Excel 201

+-------------------------------------------------------------------
|Filename: Complicated Match.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=949
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Tue, 11 Mar 2014 06:40:40 +0000 schrieb Excel Dumbo:

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.

in B12 try:
=IF(B10<0.9,0,IF(B10<=1,(B7-0.9*B6)*5,IF(B10<=2,(B7-B6)*10+0.1*B6*5,B6*10+0.1*B6*5)))


Regards
Claus B.

 

[Excel Dumbo]

THanks heaps Claus. As helpful as alway

+-------------------------------------------------------------------
+-------------------------------------------------------------------