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

hide cookie message
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.

Like this post
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?

Sheet 3

Like this post
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

Like this post
compumac

Likes # 0

What exactly do you show in D3 as a formula?

Like this post
Woolwell

Likes # 0

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

Like this post
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.

Like this post
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??

Like this post
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.

Like this post
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.

Like this post
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

Like this post
Woolwell

Likes # 0

See my 3.33pm post.

Like this post  

Reply to this topic

This thread has been locked.



IDG UK Sites

The 30 best TV shows on Netflix UK: Our pick of the best programmes you can watch right now

IDG UK Sites

Nostalgia time: Top 10 best selling mobile phones in history

IDG UK Sites

VFX Emmy: Game of Thrones work garners gong for Rodeo FX

IDG UK Sites

Apple 13-inch MacBook Pro with Retina review (2.6GHz, 128GB, mid-2014)