Hello,
I am using the "VLOOKUP" function in several columns of my workbook. When I try to add a nested "IF.ERROR" statement, some of the columns (not all) suddenly only show the text of my formula (no calculation), as though I did not have the equal (=) sign before the formula. I've tried text to columns but nothing seems to be working. Any help would be appreciated.
Thank you!
Format the cells with the formula as General, then Re-Enter the formula.
That usually means the cells are formatted as text.
Change the cell format to General then re-enter the formulas.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Great, thanks! It worked.
Good deal. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks