15 thoughts on “How to fix #VALUE error in your Excel formulas

  1. Thank you so much. I didn’t know space will cause problem in excel. Spend hours online try to find out why mine won’t calculate and show me “value” error. After watch your video and I went back to see what’s wrong with my cell. Removed the space before my number, my problem fixed.

  2. I have been chasing a formula value error for 2 days and the didn't realize the command needed for an array formula. Thanks for the help!!!

  3. OMG, I wish every solution was so easy. I've been plagued for years by that stupid error and now it's solved!! Thanks for posting. 8)

  4. Hi. I have a problem in my excel (on Mac) where I insert numbers into certain random cells and it doesn't recognize it as a number/ current no matter how many times I try to format the cell… no idea what to do or what the issue could be. Do you know perhaps? thanks!!

Leave a Reply

Your email address will not be published. Required fields are marked *