first formula....loose the SUM
=M2-F2

second

Do you mean I want the value of A1 add .20 (pence) and 3.4% of A1?

= A1 + 0.2 +(( A1 / 100)*3.4)


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=398163