Thank you for your reply - I appreciate that my post is probably
sounding a bit confusing - your reply nearly worked but did not provide
the result I was looking for - I will try to explain further -

In the second part of the equation i.e. where A2 is 10% I am looking
to return a result in C2 based on D2 less the value of cell B2 or 10%
of cell D7 (whichever is the higher of the 2 cells) -

Dont know if this helps to make clearer


--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=572846