Amanda Faramus
New Member
- Joined
- Sep 22, 2014
- Messages
- 3
Column A | Column B | Column C | Column D | |
Client | Net Amount | VAT at 20% | Gross Total | |
Row 1 | Fred Blogs | £1,500 | ||
Row 2 | *** | £2,000 | ||
Row 3 | ** *** | £3,000 |
<tbody>
</tbody>
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.
Thanks
Amanda