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

Tat was lengthy, but not quite clear.
Could you send me sample data and expected results.

HTH
--
AP

"Huck" a écrit dans le message de
...
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

Why =IF(N3=0,0,N3*C4)*0.000265
when =N3*C4*0.000265 gives the same answer?

We need some idea of the layout of your data to answer you.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Huck" wrote in message
...
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

O.K. This spreadsheet is laid out like this On the left is a list of my
customers two rows each. On top is the months Jan thru Dec. set in landscape.

Customer Jan Feb - - - - - - - - - Dec Det Sani Rinse
Cust 1 B4 C4 D4 E4 N4
B5 C5 D5 E5 N5

So I enter the meter readings in each cell in row 4 each cell in row five
has this type of function =IF(C3=0,0,C3-B3) The IF funtion is there so when
the month is at 0 the cell C5 for example will read 0 not a negative number.
So N4 under the Det column represents mililiters dispensed in each load I
have this funcion in N4
=IF(N3=0,0,N3*C4)*0.000235
the IF function is so N4 will read ) when N3 is at 0 So I multiply N3,
(dispensed Mililiters) X Number of loads, (C4) gives the answer in N4. what I
want is when I enter the next month meter, (D3) N4 will switch automatically
to multiply the # of loads for that month, (D4) If you need further
explanation I can email file
Thanx
Huck
"Bernard Liengme" wrote:

Why =IF(N3=0,0,N3*C4)*0.000265
when =N3*C4*0.000265 gives the same answer?

We need some idea of the layout of your data to answer you.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Huck" wrote in message
...
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

Please send me file (to my email, not the group)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Huck" wrote in message
...
O.K. This spreadsheet is laid out like this On the left is a list of my
customers two rows each. On top is the months Jan thru Dec. set in
landscape.

Customer Jan Feb - - - - - - - - - Dec Det Sani Rinse
Cust 1 B4 C4 D4 E4 N4
B5 C5 D5 E5 N5

So I enter the meter readings in each cell in row 4 each cell in row five
has this type of function =IF(C3=0,0,C3-B3) The IF funtion is there so
when
the month is at 0 the cell C5 for example will read 0 not a negative
number.
So N4 under the Det column represents mililiters dispensed in each load I
have this funcion in N4
=IF(N3=0,0,N3*C4)*0.000235
the IF function is so N4 will read ) when N3 is at 0 So I multiply N3,
(dispensed Mililiters) X Number of loads, (C4) gives the answer in N4.
what I
want is when I enter the next month meter, (D3) N4 will switch
automatically
to multiply the # of loads for that month, (D4) If you need further
explanation I can email file
Thanx
Huck
"Bernard Liengme" wrote:

Why =IF(N3=0,0,N3*C4)*0.000265
when =N3*C4*0.000265 gives the same answer?

We need some idea of the layout of your data to answer you.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Huck" wrote in message
...
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