Sam Longstaff
Member
Hi,
I am trying to set up a spread sheet that will monitor the total numbers of bottles of gas that we have available in the plant room. Each time the gas runs out we have to request a change over by estates who will change over two bottles. I would like to be able to monitor the total number of gas bottles available based on how many have been most recently ordered minus any change over requests but also that a total given by estates would be the master figure usurping the calculations.
I am struggling to build the formula to calculate this. Any ideas?
I am trying to set up a spread sheet that will monitor the total numbers of bottles of gas that we have available in the plant room. Each time the gas runs out we have to request a change over by estates who will change over two bottles. I would like to be able to monitor the total number of gas bottles available based on how many have been most recently ordered minus any change over requests but also that a total given by estates would be the master figure usurping the calculations.
I am struggling to build the formula to calculate this. Any ideas?