Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Good Afternoon, This must be really simple although I seem to be hitting a blank, which is really confusing me. I have a bill template that is set to work out VAT etc... At the bottom of the VAT column I have an Equation =SUM(F19:F44) although it does not seem to be adding up the pence. It seems to be rounding it up to the nearest £ I have 275.63 and 74.38 which should total 350.01 although it is showing as 350.00? Does anyone know how I can stop this happening? Many thanks, -- VickyC ------------------------------------------------------------------------ VickyC's Profile: http://www.excelforum.com/member.php...o&userid=27391 View this thread: http://www.excelforum.com/showthread...hreadid=471401 |