We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

# Tech Helproom

It's free to register, to post a question or to start / join a discussion

# Some Excel help.

gengiscant
Resolved

Likes # 0

I would like to set up an Excel spread-sheet to keep a track of my weight which is quite important at the moment. Its quite a simple sheet in that it only has three columns. so am looking for formulas to do the following.

The first line has the date, I need that to change monthly and yes I could do that each month manually.

The second is current weight.I will obviously need to input that monthly.

The third is change over the month.

The fourth is the overall change a figure that will change over the months.

I hope I have explained myself, this is a rare foray into spread-sheets and to be honest I have not got a clue really.

gengiscant

Likes # 0

You are quite correct there was no = sign because I followed you formula to the letter. So in D3 put “B3-\$C\$3” the \$ being the absolute reference and maintaining that reference. Then copy that formula down that column as far as you need to go. No = sign. But it sort of works but not what I am looking for (see screen-shot) all it seems to do is repeat the figure I have entered in the A column.What I am wanting is the overall change from the first entry to the last.

By the way how do you remove a formula?

AroundAgain

Likes # 0

Hi To remove a formula, just click on the cell containing it, and press delete, or backspace. Same as you would any entry.

Try the formula I suggested, ie =B4-\$B\$3 in cell D4. That should give you the total amount lost from the figure in B3

Cheers

compumac

Likes # 0

What exactly do you show in D3 as a formula?

Woolwell

Likes # 0

Still need to know whether you will be weighing in metric or imperial.

compumac

Likes # 0

Woolwell I think we need to get gengiscant to get the formula correct first and then sort out the KG/LB's afterwards although a very salient point I agree.

compumac

Likes # 0

gengiscant D3 should show (without inverted commas)"=B3-\$B\$2" D4 should show (without inverted commas)"=B4-\$B\$2" D5 should show (without........ ) "=B5-\$B\$2" D6 should show .................. "=B6-\$B\$2"

Make sense??

gengiscant

Likes # 0

Sorry guys column C still not sorted.(see screen-shot)76.3 is my starting figure in B2 it then jumps a bit to the figure in B3 but C3 shows a minus 2.2 when it should be a plus. In box C4 it shows minus 3.6 it should show an increase of 1.4. The figures are a tad odd.

Woolwell Its metric.

Sheet 3

Forget about D for the moment.

Woolwell

Likes # 0

As its metric there is nothing to worry about pounds and stones.

The formula in column C should read on line 3 =B3-B2, line 4 =B4-B3 and so on. Column D line 3 formula should read =B3-B\$2 then the next row =B4-B\$2 and so on.

gengiscant

Likes # 0

Have definitely sorted column C so thanks to all. (see screen-Shot). So just column to sort, just to restate what i want to do. Whereas C shows the monthly change column D will show the overall change over say a year.

Sheet 4

Woolwell

Likes # 0

See my 3.33pm post.