I want to put a sum in the "value if true".

What i want to achieve is that i add 10% to the value of the
neighbouring cell if another cell contains yes and to copy the amount
form the first cell if the second cell says no. I hope this makes
sense. You were all very helpful last time i posted a question so i
hope it works. Got to impress the boss!!!


--
Tilly
------------------------------------------------------------------------
Tilly's Profile: http://www.excelforum.com/member.php...o&userid=21809
View this thread: http://www.excelforum.com/showthread...hreadid=383838