Subtracting from values in order to 0.

[KieranW]

Hi all,

Have created an account due to this query,

Esentually I am trying to minus the value from total advised column from the values in the CUM - CRE columns (with CRE clearning last). I require the values to clear to 0 before subtracting from the next column.
i.e If 100 were advsied and you had three coulmns of 50 - you would be left with 0,0,50.

All values on the below tabel are indexed from data on other sheets (values are the result of formula).

Any assistace is appreceated!

Thanks,
K

 

[KieranW]

This may help;