You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
More on Excel spreadsheets. Like a lot of working parents, I like to volunteer when I can to help kids' sports teams and clubs. Sometimes that means getting out on the field and helping run a practice, and sometimes it means... work. Work like I do at work. Tracking things, corralling people, communication, and budgeting. Maybe not as much fun as kicking the ball around with the kids, but necessary. But, it doesn't have to be a chore. A couple of simple formulas in Excel can help you track the costs of a project at work or a kids' activity.
Here's a video introduction to the basics of Excel formulas (part of a free training course). And these two guides give you the steps:
See all of the Office Blog team's MOM 2.0 coverage from New Orleans here.
--Jessica Reading
Comments: (5) Collapse
I am using Excel 2007. I have a spreadsheet that is linked to several other spreadsheets. In a matirx of data on a sheet, there are formulas such as lookup that calculates incentives earned. However, there are a couple of cells that are not calculating. If I type the data on those cells manually then it calculates!
I have tried multiplying the data by 1 and traced formulas step by step to the original source to ensure data is not text.
Always check your formulas! The last copy made did not do what she expected. The relative reference moved down with her copy, instead of across the table she was referring to. The $50 sequential results should be a clue. Unless there is a way to change the relative reference direction when copying, she would need to create a new formula for each line.
Hey there, Broderick:
Is it possible that one of the workbooks you're linking to is closed? That causes problems sometimes. If the workbook you’re linking to is open, everything should calculate automatically, without you having to type in the cells. The following article on Office.com may shed further light on the matter:
http://bit.ly/m3FLI5
If a closed workbook isn't the problem, you might try posing your question at Microsoft Answers. For example, here's a list of questions (and answers) that deal with calculation issues:
http://bit.ly/iiIrpZ
Hope this helps!
- Anneliese
jdvaughn:
Right! That is a sage piece of advice. It's wise to always double- and even triple-check your formulas. Been burned by this myself once or twice. ;-)
- A
I have spent hours auditing every connection to these two cells in a sheet. The whole spreadsheet is fine - just the two cells that contain exactly the same formulas as the rest of the sheet refuses to calculate.
Comments: (loading) Collapse