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
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