Title: 10 Reasons for Excel Formulas not Working [and How to Fix Them]
Headings: 10 Reasons for Excel Formulas not Working [and How to Fix Them]
10 Reasons for Excel Formulas not Working [and How to Fix Them]
Excel formulas not working: Why & How to fix them
#1. CALCULATION OPTIONS [MOSTLIKEY REASONS FOR EXCEL FORMULAS NOT UPDATING]
Some other tips:
#2. EXCEL FORMULA NOT CALCULATING JUST SHOWING FORMULA [SHOW FORMULAS]
#3. EXTRA SPACE (S) IS AN EXTRA HEADACHE
Some other tips:
#4. GET RID OF NONPRINTABLE/HIDDEN CHARACTERS
#5. EXCEL FORMATTING – DON’T TRY TO COMPARE APPLES WITH ORANGES
Some other tips:
#6. CIRCULAR REFERENCES (ERRORS DUE TO AN ENDLESS CIRCLE)
#7. USING DOUBLE QUOTES INCORRECTLY – HUMAN ERROR
#8. BODMAS – BASIC RULE FOR EVERY CALCULATION
#9. INCORRECT USE OF “ABSOLUTE” REFERENCING
Some other tips:
#10. INCORRECT FORMULA ARGUMENTS
Now It’s Your Turn

Content: Do you know extra spaces cause a lot of problems while using VLOOKUP formula? Sometimes it’s quite hard to identify these spaces. For example, let’s say if you want to do Vlookup using employee name as a base, so your employee name looks like below
Now if I take a length of each name I can see first line has 12 and the second one has 13. Although both the names look similar to our naked eye, there is a blank space in the second name. This would not meet exact match criteria in VLOOKUP formula thus results in #N/A error. How to fix this issue: The extra space (s) issue can be fixed using the Trim formula. In general, the Trim formula will find out more than one space between words and it will delete. Some other tips: It’s always a good idea to use the Trim formula before you do Vlookup in both the tables (lookup & data table)
The trim function will ignore blank spaces between letters (it will only work with words)
#4.