working VAT in worksheet
 

Hi all

I have a worksheet like below, It might be easy for some but i'm a bit rusty.

F8 F9 F10
Net VAT Total

What i need is a function that will allow me to enter a amount in either Net
or Total and it would work out Vat and either Net or Total depending where i
have put the amount. Hope this makes sense!

Many thanks

Tina