Originally Posted by LSainsbury

That's what I thought - something odd happening here

Excel works it out as:

Total: £100
VAT: £16.67
Net: 83.33

Surley that should be:

Total: £100
VAT: £20
Net: £80