Home |
Search |
Today's Posts |
#1
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
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
GET.CELL | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |