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

View Forum Rules | Contact Forum Editor

 

Some Excel help.

« previous 1 3 5 … next » last »

gengiscant
Resolved

Likes # 0

Posted October 28, 2011 at 10:15AM

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

Posted October 28, 2011 at 2:12PM

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

Posted October 28, 2011 at 2:18PM

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

Posted October 28, 2011 at 2:23PM

What exactly do you show in D3 as a formula?

Like this post
Woolwell

Likes # 0

Posted October 28, 2011 at 2:23PM

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

Like this post
compumac

Likes # 0

Posted October 28, 2011 at 2:28PM

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

Posted October 28, 2011 at 2:34PM

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

Posted October 28, 2011 at 3:07PM

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

Posted October 28, 2011 at 3:33PM

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

Posted October 28, 2011 at 3:38PM

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

Posted October 28, 2011 at 3:39PM

See my 3.33pm post.

Like this post  

« previous 1 3 5 … next » last »

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.