SUM Querie
 

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

See

http://www.mcgimpsey.com/excel/pennyoff.html

In article ,
VickyC wrote:

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,

Try changing the formatting of the cell.... Format-Cells-'Number'
Tab-Click 'General' or 'Number'


--
Regards,
Dave


"VickyC" wrote:


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