ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sum of three cells (https://www.excelbanter.com/excel-worksheet-functions/193464-sum-three-cells.html)

slamon

sum of three cells
 
what i need to due is;
first cell(A1) will be the hour meter of a vehicle of when we did a check on
it. will say 100
third cell(C1)will be this months hour meter reading. say 250.
now second cell(B1) will be the differance between those =150.
i had this set up before but my hard drive died and i can not remember how i
did this.
Thanks

tim m

sum of three cells
 
In B1 put the formula =C1-A1

I assume that the values in column C will always be higher than those in
Column A?

"slamon" wrote:

what i need to due is;
first cell(A1) will be the hour meter of a vehicle of when we did a check on
it. will say 100
third cell(C1)will be this months hour meter reading. say 250.
now second cell(B1) will be the differance between those =150.
i had this set up before but my hard drive died and i can not remember how i
did this.
Thanks


slamon

sum of three cells
 
THAT WORK!
THANK YOU

"tim m" wrote:

In B1 put the formula =C1-A1

I assume that the values in column C will always be higher than those in
Column A?

"slamon" wrote:

what i need to due is;
first cell(A1) will be the hour meter of a vehicle of when we did a check on
it. will say 100
third cell(C1)will be this months hour meter reading. say 250.
now second cell(B1) will be the differance between those =150.
i had this set up before but my hard drive died and i can not remember how i
did this.
Thanks



All times are GMT +1. The time now is 05:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com