Hello,
I have a table which has a number column (10 decimal places) and a precision column (0,1,2,3). I want to convert the number based on the corresponding precision value. I'm using the TEXT formula, however unable to reference it to the Precision column.
Ex:
Number - Precision - TEXT
9.6566545665 - 3 - TEXT(A1,B1) should return 9.657
I don't want to convert the precision to '0.000, I want to keep it as 0,1,2,3.
Any help is greatly appreciated.
Regards,
Kalyan Verma
Why not:
=ROUND(A1,B1)
You can use TEXT but the above should be sufficient
=TEXT(A1,"#."&REPT(0,B1))
But the above would be a Text string...and if you want a number you should use ROUND as illustrated.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Awesome, Thanks a Million.
Ran into an Issue.
What if my Precision is 0, it shows the value as "9."
Regards,
Kalyan Verma
If using TEXT:
=0+TEXT(A1,"#"&IF(N(B1),"."&REPT(0,B1),""))
or
=ROUND(A1,B1) .....
Thanks, It worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks