Why does excel tell me that there is an error in column K, when i have another formula in column L? If the cell in column L is empty, excel thinks everything is fine.
The formula in column K is almost identical with the one in column I (capital i), which doesn't render any error message.
Last edited by rasmerla; 09-15-2011 at 11:06 AM. Reason: Solved
Because the formula in column L is effectively the same as the formula in column J, so Excel thinks the formula in the middle (col K) should probably be the same. Personally I turn off that error checking option as I find it useless more often than not.
Anyone who confuses correlation and causation ends up dead.
That's what I call a quick answer! Thanks a lot for the help! I couldn't stand being ignorant about the reason. ;-)Originally Posted by romperstomper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks