the formula for the vat is sum(cell)*17.5%. total is just sum(cells). it
seems to be only one entry that is causing the problem. everything is fine
until this cell has a value in it. if i enter the value manually it is fine.

£18,681.75 £3,269.31 £21,951.06

this is the data with the problem.

Thanks, Lisa


"Roger Govier" wrote:

Hi Lisa
Can you post some examples of your data, the formula you are using for the
VAT calculation and the formula you are using to total.
Regards

Roger Govier


Lisa wrote:
i am totaling a column with vat formulas in, but the total column keeps
rounding the figuredown. If i enter the amounts manually they add up fine.