dahermit Posted March 21, 2010 Posted March 21, 2010 I am using Windows 7 64-bit computer that comes preloaded with MS Works. Using the MW Works spread sheet I get incorrect data. For instance, using a formula: =SUM(D1-G2) If I had the number 34 in Cell D1 and the number 30 in the cell G2 I should get the number 4 in the cell in which the formula is placed. However, I get the contents of cell G2. What gives? What is causing this. Most of the spread sheet is giving correct answers. Note: could this be caused by opening a spreadsheet constructed by an earlying verson of MW Works in the Current version(9)?
jaclaz Posted March 21, 2010 Posted March 21, 2010 I am using Windows 7 64-bit computer that comes preloaded with MS Works. Using the MW Works spread sheet I get incorrect data. For instance, using a formula: =SUM(D1-G2) If I had the number 34 in Cell D1 and the number 30 in the cell G2 I should get the number 4 in the cell in which the formula is placed. However, I get the contents of cell G2. What gives? What is causing this. Most of the spread sheet is giving correct answers. Note: could this be caused by opening a spreadsheet constructed by an earlying verson of MW Works in the Current version(9)?Hmmm.What happens with =SUM((D1-G2))?What happens with =D1-G2 ?jaclaz
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now