|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 27th, 2005, 10:05 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"the formula in this cell differs from the formula in this area o.
I keep getting this error "the formula in this cell differs from the formula
in this area of the spreadsheet" when I put a formula in my time spreadsheet. I know it is something simple but cannot figure out what! Because of this error the total hours worked will not total correctly. I am using military time to calculate my hours worked as it rounds up with how I am paid. 
|
|
#2
November 27th, 2005, 10:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"the formula in this cell differs from the formula in this area o.
What formulas in what cells? Which one gave the "error" message? What is the
difference? What are the input values? What result did you expect? What did you get instead? -- Kind regards, Niek Otten "~Summiya~" wrote in message ... I keep getting this error "the formula in this cell differs from the formula in this area of the spreadsheet" when I put a formula in my time spreadsheet. I know it is something simple but cannot figure out what! Because of this error the total hours worked will not total correctly. I am using military time to calculate my hours worked as it rounds up with how I am paid.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Text in formula bar is not displaying in cell | Mike | General Discussion | 0 | August 29th, 2005 09:47 PM |
| put formula results into a different cell if it is empty | PutFormula | Worksheet Functions | 2 | February 11th, 2005 03:31 AM |
| How is it that a cell can transfer the correct formula, but th | kbigs | General Discussion | 1 | January 12th, 2005 03:56 PM |
| use a formula to create a empty cell | Chas | Charts and Charting | 1 | October 27th, 2004 11:14 PM |
| How to lock one cell in formula? | Worksheet Functions | 2 | December 26th, 2003 01:22 PM | |
Linear Mode
