Five Ways To Fix #VALUE Errors in Microsoft Excel

Thank you so much

helpfullllllll, Thanks

Thanks you so much very helpful

Wow, very helpful indeed. Many thanks.

thank you, it responds my questions correctly, nice video : ))

Thanks Teacher 💪🏼

Hi - I have this value issue when I used vlookup to another sheet. Intially I get the results but when I open the independent sheet it throws me the error. This error fixs when I open the document which I linked the formula to

After watching this I went back to my spreadsheet & lo! I discovered that my problem was I had copy pasted the data from Microsoft word. When I re-typed the data, it worked like a charm. Problem solved. Thank you for taking up this issue. Really appreciate it.

Great video ...with Perfect Salution ...thank you so much ..for solving same issue I had faced to ...But Now solved ...god bless you always...and keep making videos and Helping us ... I Subscribed your channel now ....💖

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.

Duuuuuude you are awesome

Thanks Very useful.

Very useful, no fluff, errors very well illustrated - will bookmark this for sure.

I kept getting the error. the problem was that a had for example 20.36 +10.56, my excel did not reconized the point, I had to change it for a comma instead of a point. 20,36. Thanks for the video it helped me a lot

Thank you for your assistance, its really resourceful. However, I was stocked not realizing that an hype (-) was used instead of dot (.) but this video helped out, thank you.

Hi,can anybody solve this problem please .. i have "value error" =IF(B2<=250000,3%*B2),IF(B2<=500000,7500+(B2-250000)*5%),IF(B2<=1000000,20000+(B2-500000)*10%),IF(B2>1000000,70000+(B2-1000000)*15%) thanks

kindly help to fix this
=(E6-E6*G6)*(F6)

=(E6-E6*G6)*(F6)

how about this why isn't working ? "=SUM(H5-E13:E16)" H5 = £8,664.54 E13:E16= £1,545.63 + £1,114.24+ £2,554.89+ £3,001.15
thank you

very helpful. thank you very much.

Thank you very much!!!!!!!!!!!

good video keep it 👆

Thank you thank you thank you 🙏🙏🙏🙏🙏🙏🙏 took me hours to understand why. It was one wrong symbol and problem solved!!!

very helpful... Thank you

Very useful!!!

When I use datedif function appears value ?!!