software

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

quot;Huckquot; gt; a écrit dans le message de
...
gt; Excuse me if this is lengthy. I have a spreadsheet that calculates meter
gt; readings for dishmachines. it is a twelve month calendar. As I enter the
gt; reading for Feb, (for example) it subtracts jan. from feb. and gives a
load
gt; count for feb. and so on. I also have a chemical usage calculator in one
cell
gt; what I want to do is use the one cell to calculate the chemical usage for
gt; each month and display the latest month I.E.
gt; if I'm on march I want it to display march. each customer is on a row from
gt; B4 to M4 for example I want a function that will update to each month as I
gt; enter the digits. here is what I have so far =IF(N3=0,0,N3*C4)*0.000265
gt; N3 is the cell for chemical usage entered in mls I multiply that number by
gt; the loads for the month,(C4) then multiply by .000265 to convert to
gallons.
gt; If I could ad a string to advance to the next month as I enter it and
display
gt; 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

quot;Huckquot; gt; wrote in message
...
gt; Excuse me if this is lengthy. I have a spreadsheet that calculates meter
gt; readings for dishmachines. it is a twelve month calendar. As I enter the
gt; reading for Feb, (for example) it subtracts jan. from feb. and gives a
gt; load
gt; count for feb. and so on. I also have a chemical usage calculator in one
gt; cell
gt; what I want to do is use the one cell to calculate the chemical usage for
gt; each month and display the latest month I.E.
gt; if I'm on march I want it to display march. each customer is on a row from
gt; B4 to M4 for example I want a function that will update to each month as I
gt; enter the digits. here is what I have so far =IF(N3=0,0,N3*C4)*0.000265
gt; N3 is the cell for chemical usage entered in mls I multiply that number by
gt; the loads for the month,(C4) then multiply by .000265 to convert to
gt; gallons.
gt; If I could ad a string to advance to the next month as I enter it and
gt; display
gt; 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
quot;Bernard Liengmequot; wrote:

gt; Why =IF(N3=0,0,N3*C4)*0.000265
gt; when =N3*C4*0.000265 gives the same answer?
gt;
gt; We need some idea of the layout of your data to answer you.
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Huckquot; gt; wrote in message
gt; ...
gt; gt; Excuse me if this is lengthy. I have a spreadsheet that calculates meter
gt; gt; readings for dishmachines. it is a twelve month calendar. As I enter the
gt; gt; reading for Feb, (for example) it subtracts jan. from feb. and gives a
gt; gt; load
gt; gt; count for feb. and so on. I also have a chemical usage calculator in one
gt; gt; cell
gt; gt; what I want to do is use the one cell to calculate the chemical usage for
gt; gt; each month and display the latest month I.E.
gt; gt; if I'm on march I want it to display march. each customer is on a row from
gt; gt; B4 to M4 for example I want a function that will update to each month as I
gt; gt; enter the digits. here is what I have so far =IF(N3=0,0,N3*C4)*0.000265
gt; gt; N3 is the cell for chemical usage entered in mls I multiply that number by
gt; gt; the loads for the month,(C4) then multiply by .000265 to convert to
gt; gt; gallons.
gt; gt; If I could ad a string to advance to the next month as I enter it and
gt; gt; display
gt; gt; on the same cell which is N4. I would apreciate any help
gt;
gt;
gt;

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

quot;Huckquot; gt; wrote in message
...
gt; O.K. This spreadsheet is laid out like this On the left is a list of my
gt; customers two rows each. On top is the months Jan thru Dec. set in
gt; landscape.
gt;
gt; Customer Jan Feb - - - - - - - - - Dec Det Sani Rinse
gt; Cust 1 B4 C4 D4 E4 N4
gt; B5 C5 D5 E5 N5
gt;
gt; So I enter the meter readings in each cell in row 4 each cell in row five
gt; has this type of function =IF(C3=0,0,C3-B3) The IF funtion is there so
gt; when
gt; the month is at 0 the cell C5 for example will read 0 not a negative
gt; number.
gt; So N4 under the Det column represents mililiters dispensed in each load I
gt; have this funcion in N4
gt; =IF(N3=0,0,N3*C4)*0.000235
gt; the IF function is so N4 will read ) when N3 is at 0 So I multiply N3,
gt; (dispensed Mililiters) X Number of loads, (C4) gives the answer in N4.
gt; what I
gt; want is when I enter the next month meter, (D3) N4 will switch
gt; automatically
gt; to multiply the # of loads for that month, (D4) If you need further
gt; explanation I can email file
gt; Thanx
gt; Huck
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; Why =IF(N3=0,0,N3*C4)*0.000265
gt;gt; when =N3*C4*0.000265 gives the same answer?
gt;gt;
gt;gt; We need some idea of the layout of your data to answer you.
gt;gt; best wishes
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;Huckquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Excuse me if this is lengthy. I have a spreadsheet that calculates
gt;gt; gt; meter
gt;gt; gt; readings for dishmachines. it is a twelve month calendar. As I enter
gt;gt; gt; the
gt;gt; gt; reading for Feb, (for example) it subtracts jan. from feb. and gives a
gt;gt; gt; load
gt;gt; gt; count for feb. and so on. I also have a chemical usage calculator in
gt;gt; gt; one
gt;gt; gt; cell
gt;gt; gt; what I want to do is use the one cell to calculate the chemical usage
gt;gt; gt; for
gt;gt; gt; each month and display the latest month I.E.
gt;gt; gt; if I'm on march I want it to display march. each customer is on a row
gt;gt; gt; from
gt;gt; gt; B4 to M4 for example I want a function that will update to each month
gt;gt; gt; as I
gt;gt; gt; enter the digits. here is what I have so far
gt;gt; gt; =IF(N3=0,0,N3*C4)*0.000265
gt;gt; gt; N3 is the cell for chemical usage entered in mls I multiply that number
gt;gt; gt; by
gt;gt; gt; the loads for the month,(C4) then multiply by .000265 to convert to
gt;gt; gt; gallons.
gt;gt; gt; If I could ad a string to advance to the next month as I enter it and
gt;gt; gt; display
gt;gt; gt; on the same cell which is N4. I would apreciate any help
gt;gt;
gt;gt;
gt;gt;