Thread
:
Lookup functions in Works Spreadsheet 8.0
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
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 With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann