G
GarrettSocling
=(D108-D$15)/D$15 for example. The rows head down =(D102-D$15)/D$1
=(D104-D$15)/D$15 =(D106-D$15)/D$15 =(D108-D$15)/D$15etc etc etc. Eac
D102, D104, is each days data. D15 is a constant which each days data i
divided by.
If the data in D102 on down isn't present, then each cell on down wil
display -100.0%, which it gets from trying to divide a blank cell b
D15.
:confused
=(D104-D$15)/D$15 =(D106-D$15)/D$15 =(D108-D$15)/D$15etc etc etc. Eac
D102, D104, is each days data. D15 is a constant which each days data i
divided by.
If the data in D102 on down isn't present, then each cell on down wil
display -100.0%, which it gets from trying to divide a blank cell b
D15.
:confused