IF function giving error message
I am no longer able to enter an IF function - I simply get the message "the formula typed contains an error". Existing IF functions still work but can't be edited. If I open the workbook with OpenOffice, enter the IF functions and save to Excel then it works - but still can't edit the formula from Excel. I have tried uninstalling Ms Office and reinstalling but problem persists. Anyone any idea what has gone wrong.
Post the actual formula here
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
=LOOKUP($B18 Pricesheet!$A$3:$A$82 Pricesheet!$I$3:$I$82)/100
Shouldn't this formula have commas to separate the arguments? Where did they go?
Regards
Mike
The formula you posted is not an If function
Where is the If function that you described as being a problem in your thread title and the original posting for this thread
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Maybe you can also post the workbook showing the problem and indicating when/where the problem occurs.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks