If you really must have it in *one* cell, try this in J49:

=SUM(J45,J46,J48,-J47)*1.175

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"jsansom" wrote in
message ...

J 49 looks like this =J45+J46+J48-J47

If i add =j49*1.175 to the end so i get =J45+J46+J48-J47=j49*1.175 or
even remove the = to this =J45+J46+J48-J47=j49*1.175 neither work?

Im being dumb arnt i?? sorry to ask but exactley what do i need to put
in on my cell J49 which at the moment is reading =J45+J46+J48-J47


or maybe i could send the sheet so you can see what im doing wrong?

Regards

Jeremy

P.s thanks for responding


--
jsansom
------------------------------------------------------------------------
jsansom's Profile:
http://www.excelforum.com/member.php...o&userid=28754
View this thread: http://www.excelforum.com/showthread...hreadid=484426