Tushar Mehta Wrote:
Assuming the values you describe are in cells A1:D1, the formula you
want is:

=MAX(0,D1-MAX(A1,B1))*3+MAX(0,MIN(D1,A1)-B1)*1

The above has been lightly tested.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

I missed your message... :(

Although when I saw it I tried your formula and it worked flawlessly
:D

Thanks alot! :D


--
JemyM
------------------------------------------------------------------------
JemyM's Profile: http://www.excelforum.com/member.php...o&userid=26945
View this thread: http://www.excelforum.com/showthread...hreadid=401682