is there a function that will multiply different cells

[Guest]

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

 

[Ardus Petus]

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

HTH

 

[Bernard Liengme]

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

 

[Guest]

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]

Please send me file (to my email, not the group)