Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup functions in Works Spreadsheet 8.0
When I use a formula in a lookup function and I save the file and close the
file Works 8.0 adds +1-1 to the end of my lookup function. This is done every time I save & close the file. This can get very long & cause the formula to return an error message. If I use whole numbers i.e. 2, 5, 16,2013, etc. ,it will not add +1-1 to the formula. What's up with this? -- cityboyjerry |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup functions in Works Spreadsheet 8.0
This is an Excel Newsgroup, try in the works newsgroup
microsoft.public.works.win -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "cityboyjerry" wrote in message ... When I use a formula in a lookup function and I save the file and close the file Works 8.0 adds +1-1 to the end of my lookup function. This is done every time I save & close the file. This can get very long & cause the formula to return an error message. If I use whole numbers i.e. 2, 5, 16,2013, etc. ,it will not add +1-1 to the formula. What's up with this? -- cityboyjerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
ms works spreadsheet | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Need help with MS works Spreadsheet | Excel Worksheet Functions | |||
How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) |