The formula bj suggested works *exactly* as you asked!
In your example in your OP, you never stated what value was in D2.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"martins" wrote in
message ...
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