is there a function that will multiply different cells

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" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>>
>>
>>