| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function fails to calculate
I enter a text function in excel 2003, correct syntax, but instead of showing
the result the cell continues to show the function. Calculation options don't affect the result. For example, if cell A2 is "AL TOTAL" and I enter "=left(A2,2)" in another cell, I should get just "AL". Instead I sometimes get the function "=left(A2,2)" shwoing indefinitiely. This seems to happen with large spreadsheets. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want the PMT function to calculate using 360 days not 365 | Excel Worksheet Functions | |||
| Function to calculate the interest of a mortgage | Excel Worksheet Functions | |||
| Function Won't Calculate -- Sometimes | Excel Discussion (Misc queries) | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
| In Excel, why sort function fails when applied to a list of date? | Excel Discussion (Misc queries) | |||
Threaded Mode
