How to fix #VALUE error in your Excel formulas

This video helps you fix the #VALUE error in Microsoft Excel.

You’ll learn the common causes of the #VALUE error in Excel formulas and you’ll see techniques for eliminating the #VALUE error in Excel using other Excel formulas (SUM, PRODUCT, and arrays).

Click on the link above for a printable PDF of all the solutions covered in this video.

[ddolan]

How about the #value error because the cell does not yet contain a value?

[preciousannecantaros]

Thank you so much for this excel tutorial. I hope other people will find this video helpful as well as it helped me. Also may I share this verse here? They replied, “Believe in the Lord Jesus, and you will be saved—you and your household.” Acts 16:31 Let us believe in Jesus Christ! God bless you!

[larryrbannister]

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)

[karlprasher]

I was pulling my hair out trying to solve my excel errors until I came across this video. Life saver!

[chrisgtrMining]

CONTROL SHIFT ENTER wow so many years on excel lol., i know google sheet makes this work right as u enter it but damn my man thanks

[MsGopzz]

I got issue with subtraction eg: =c2-u2 I get error #value. Can anyone help please.

[nafisatuthullah]

This has been very helpful to me as I have been trying all along how to fix these errors and spending hours without having the answer until after watching this video. Thank you so much Pete.

[tinyikonkuna]

How do we use the division sign then sir!!! BECAUSE FUNCTIONS Has no division sign.. I am still getting this #value

[kamranakhtargilani]

Great bro, Solved my problem at 1 AM midnight when I was not able to call anyone to ask a little thing

[Yuri-xjhx]

Thanks alot, very helpful for my financial report

[nayemhayder]

Thank You very much. It was very helpful.

[mgeniwamwachai]

If you are trying to work on google drive try opening the document with the excel app and correcting the issue there. Worked for me and automatically also corrected the file on drive.

[sumitayare]

how to remove value error when there is both subtraction and multiplication formula in it. eg : =(g4-b4)*b4

[leviv]

I am using the datedif formula and I an getting the #value! error. I am not sure why ... any suggestion?

[shamamba]

thanks sir. you saved my steel excel proposal. 😂

[sunilpinto]

When your requirement of C3+D3, you avoided result of #Value by changing the function as Sum(C3:D3). My requirement is C3-D3, how I can avoid the result of #Value?

[ashleysaffluence]

The product formula just saved my life lol THANK YOU SO MUCH!

[crystalpenaloza]

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.

[jomerdullin]

Thank you so much man! This would will help through my career

[nirupexgurungx]

Thank you very much really appreciate your work