Hello All i need help with this NUMBERVALUE in excel 2007 i create this formula =IFERROR(NUMBERVALUE(RIGHT(A4,4)),0) in excel 2013 but when i try to run it in excel 2007 is not working and i get this =IFERROR(_xlfn.NUMBERVALUE(RIGHT(A4,4)),0) can someone please help me find another way to run this formula in excel 2007
Thanks you in advance
Can you try:
=IFERROR(VALUE(RIGHT(A4,4)),0)
If I've helped U pls click on d *Add Reputation
OR,
Try the following:
=IFERROR(1*RIGHT(A4,4),0)
Regards,
Chandra
Be brave. Take risks. Nothing can substitute experience. - Paulo Coelho
WOW Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks