Dependent formula

Copper Contributor

Hi

I am trying to build a couple of formulas to work back to a gross sale figure in my attached spreadsheet (cell H13).

 

Cell H19 is to be a % of H13 when calculated

Cell H17 is to be the VAT % of H13 when taking into account cell H19.

 

The idea being you can work back to the figures in column H without touching any of the cells in Column H

 

Any clever people out there :) ?

 

1 Reply

@Del-71 

 

Attached is the sheet and screen shots

 

clipboard_image_0.png