Simple, I HOPE...

**ShrOOmiEs** · 11-08-2006, 03:30 AM

I’m writing up a spread sheet to help me monitor my weight. Here is the goal.

Day--------Day Weight-----Night Weight---Pounds Gain/Lost
11/7/2006------170------------169----------- -1
11/8/2006------169------------171------------ 2

This is a quick example of something I want to set up... I want there to be a negative number of pounds I lost from day to night and a positive number for what I have gain that day to night.

I’m pretty sure it’s possible, I’m just not aware of how to do it any help will be greatly appreciated.

Thanks in advance.

**Simon Lloyd** · 11-08-2006, 03:40 AM

Hi assuming you want the results in colum D paste this in to D2 (assuming row 1 has your headings)

Please Login or Register  to view this content.

then once you have copy down for your full range you expect to cover.

Regards,
Simon

**ShrOOmiEs** · 11-08-2006, 05:05 AM

Originally Posted by Simon Lloyd

Hi assuming you want the results in colum D paste this in to D2 (assuming row 1 has your headings)

Please Login or Register  to view this content.

then once you have copy down for your full range you expect to cover.

Regards,
Simon

thanks for trying but thats not exactly what im looking for because the code u posted is what i have now... im looking for somthing a little more complicated... if i got over my origonal wieght then its a positive number if it goes below my weight then its a negative number. Im still looking and trying...

**Simon Lloyd** · 11-08-2006, 05:12 AM

Shroomie your not explaining yourself very well, what is your original weight? where will this be stored? what is it exactly you are tryin to do?

Regards,
Simon

**ShrOOmiEs** · 11-09-2006, 12:12 AM

it was actually very clear, but i figured it out.

Simple, I HOPE...

LinkBack

Thread Tools

Rate This Thread

Display

Simple, I HOPE...

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions