Hey everyone,

I need a formula to calculate meter flow.

Each day I get a flow reading. I must subtract the following days reading to get my daily flow.

The meter may have zeros in the beginning and must have three zeros at the end.

My formula must keep any zeros at the front and add three zeros in the end and the calculate the actual gallons per day.

Here is my example and how I formatted the sreadsheet.

Thanks for the help.  Register To Reply

2. ## Re: Meter Reading Problem

Right click on cell -> Format cells -> Number -> use 3 decimal places AND thousand separator

(also, since you not here first time it would be nice to state your Excel version in your profile . It won't impact you in any case and it can be helpful for giving solutions).  Register To Reply

3. ## Re: Meter Reading Problem

or change formula to
=(B3-B2)*1000  Register To Reply

4. ## Re: Meter Reading Problem Originally Posted by zbor Right click on cell -> Format cells -> Number -> use 3 decimal places AND thousand separator

(also, since you not here first time it would be nice to state your Excel version in your profile . It won't impact you in any case and it can be helpful for giving solutions).
Thanks for the reply. I updated my profile. Using 2003.

I tried your formula, it gives me a decimal point instead of a comma.  Register To Reply

5. ## Re: Meter Reading Problem Originally Posted by martindwilson or change formula to
=(B3-B2)*1000
Outstanding.

Worked perfectly.

Such a simple change.

Thanks  Register To Reply