Resolving #VALUE! errors in Microsoft Excel

Resolving #VALUE! errors in Microsoft Excel

1 June 2013

It's a frustrating experience when a simple Excel spreadsheet displays #VALUE! in a worksheet cell rather than the expected result. Many times the problem is obvious, in that you've tried to do arithmetic using text and numbers, but sometimes the culprit is harder to track down.