is there a function that will multiply different cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Tat was lengthy, but not quite clear.
Could you send me sample data and expected results.

HTH
 
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
 
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
 
Back
Top