# Reverse Formulas from the Total

#### Amanda Faramus

##### New Member
 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>
Hello,

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

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### Comfy

##### Well-known Member
There are a couple of ways.

Excel 2010
ABCDE
1Column AColumn BColumn CColumn D
2ClientNet AmountVAT at 20%Gross Total
3Row 1Fred Blogs£1,250.00£250£1,500
4Row 2***£1,666.67£333£2,000
5Row 3** ***£2,500.00£500£3,000
Sheet1
Cell Formulas
RangeFormula
C3=E3/1.2
D3=E3/6

#### Amanda Faramus

##### New Member
There are a couple of ways.

Excel 2010
ABCDE
1Column AColumn BColumn CColumn D
2ClientNet AmountVAT at 20%Gross Total
3Row 1Fred Blogs£1,250.00£250£1,500
4Row 2***£1,666.67£333£2,000
5Row 3** ***£2,500.00£500£3,000

</tbody>
Sheet1

Worksheet Formulas
CellFormula
C3=E3/1.2
D3=E3/6

</tbody>

<tbody>
</tbody>

Thank you so much for the response it works perfectly.

#### Amanda Faramus

##### New Member
Thank you so much Comfy it worked perfectly.

Replies
8
Views
2K
Replies
5
Views
725
Replies
13
Views
674
Replies
6
Views
3K
Replies
24
Views
1K

1,191,379
Messages
5,986,285
Members
440,016
Latest member
vasanrajeswaran

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back