Excuse me if this is lengthy. I have a spreadsheet that calculates meter
readings for dishmachines. it is a twelve month calendar. As I enter the
reading for Feb, (for example) it subtracts jan. from feb. and gives a load
count for feb. and so on. I also have a chemical usage calculator in one cell
what I want to do is use the one cell to calculate the chemical usage for
each month and display the latest month I.E.
if I'm on march I want it to display march. each customer is on a row from
B4 to M4 for example I want a function that will update to each month as I
enter the digits. here is what I have so far =IF(N3=0,0,N3*C4)*0.000265
N3 is the cell for chemical usage entered in mls I multiply that number by
the loads for the month,(C4) then multiply by .000265 to convert to gallons.
If I could ad a string to advance to the next month as I enter it and display
on the same cell which is N4. I would apreciate any help