- Sep 22, 2014
|Column A||Column B||Column C||Column D|
|Client||Net Amount||VAT at 20%||Gross Total|
|Row 1||Fred Blogs||£1,500|
|Row 3||** ***||£3,000|
I am not sure if this is possible.
I would like to be able to add formulas to column B and column C, Rows 1, 2 and 3, so that when I add the gross total (as you can see the £1,500 in Row1/Column D) in my table above the other two automatically show the Net Amount and VAT at 20% amount. Is this in fact possible?
Row 1/column B should be £1,250
Row 1/column C should be £250
I am sorry if I have not explained this very well.