SUM Querie

  • Thread starter Thread starter VickyC
  • Start date Start date
V

VickyC

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'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Query problem 1
Validation of UK VAT Number 20
How do i round up a price to the nearest 5,10,15 etc pence 1
Help to calculate Drinking Fountains 2
how to add 17.5% vat formula 7
Designjet HP111R - faulty 1
Round down a weighted average 2
Calculating Sum - when numbers are rounded... 2

Back
Top