Asha Kanta Sharma
asked on
Switched from Excel 2013 to 2010 becasue of which Excel Formula like NA, NUMBERVALUE etc not working
Hi Experts,
I have recently switched from MS Excel 2013 to 2010 becasue of which formulas like NA, NUMBERVALUE are not working.
Any help how to get the above formulas working into Excel 2010.
Thanks
Asha Kanta Sharma
made_ash@yahoo.co.in
I have recently switched from MS Excel 2013 to 2010 becasue of which formulas like NA, NUMBERVALUE are not working.
Any help how to get the above formulas working into Excel 2010.
Thanks
Asha Kanta Sharma
made_ash@yahoo.co.in
The syntax of the function is:
NUMBERVALUE( text, [decimal_separator], [group_separator] )
eg =NUMBERVALUE("2.500,27",", ",".") = 2.500.27
eg =NUMBERVALUE("3.5%") =0.035
NUMBERVALUE( text, [decimal_separator], [group_separator] )
eg =NUMBERVALUE("2.500,27",",
eg =NUMBERVALUE("3.5%") =0.035
ASKER
OK. Value Function is working fine. Now what are the alternatives of IFNA Function ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My issues are now resolved. Thanks Roy_Cox and Rob Henson.
Keep sharing ......
Keep sharing ......
Pleased to help
See this