Trying to subtract

**mlg1976** · 08-23-2012, 03:22 AM

Hi there,
This will most likley sound silly, I am a huge lover of excel but I have a mental blank and its driving me crazy! I am tring to create a formula that subtract from each other as new figures are entered. For example, I enter the daily fuel usage in a service station, the dip entered for Diesel each day goes into one colum, in colum 32A I am trying to have this colum show the amount of diesel used for the month... see below

Date Daily Dip

1 65,000
2 61,000
3 57,000
etc
etc
etc

TOTAL USED 37,000

I need the total field to subtract the daily dip from the opening dip.... is there a simple formula or do I need to do each cell on its own meritt?

Thanks
Matt

**vlady** · 08-23-2012, 03:28 AM

??

if the first dip is in A1
in B2 =A1-A2 --fill formula down...

or for the last row

=A1-Last dip

**mlg1976** · 08-23-2012, 04:04 AM

Fuel Dips.xlsx

Try this

**vlady** · 08-23-2012, 04:16 AM

maybe like this

Fuel Dips.xlsx

**vlady** · 08-23-2012, 07:10 PM

thank for the nice words and star tap.
if ever you come across again in the forum can you mark this thread "solved".

go tto the first post click edit-then follow instruction below my signature.

thanks. again.

**verduco9** · 08-24-2012, 04:43 PM

Hello I am a newbie here. I have a simple formula =SUM(F16-J16) and F16 is 819.38 and J16 is 66.29. The result come out to 753.08, however, it should be 753.09 idk what I'm doing wrong help!

**Cutter** · 08-24-2012, 05:27 PM

Hello verduco9, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.