LinkBack URL
About LinkBacks
In a cell I am multiplying 21.23*25.25 = 536.1728392225
By formating in cell it shows 536.17 but in formula bar it is still showing 536.1728392225
How can I show the result same in both cell and in fomula bar as 536.17
Can anyone help on this.
In a cell I am multiplying 21.23*25.25 = 536.1728392225
By formating in cell it shows 536.17 but in formula bar it is still showing 536.1728392225
How can I show the result same in both cell and in fomula bar as 536.17
Can anyone help on this.
in formula bar its showing 536.1728392225
or
=21.23*25 ...???
If answer helped you say Thanks by Add Reputation
21.23*25.25 = 536.05750000000000 not 536.1728392225
You cannot.How can I show the result same in both cell and in fomula bar as 536.17
The cell actually contains the full value, but has been set to only display 2 decimal places.
The only way to make the actual answer have 2 decimal places is to use the ROUND() function...
=ROUND(21.23*25.25,2)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
21.23*25.25=536.1728392
In formula bar it is showing 536.1728392
In need 536.17
I am testing your formula and will let you know if it works.
No, sorry. 21.23*25.25 = 536.05750000000000 not 536.1728392225Originally Posted by Shahadat65
The ONLY way that 21.23*25.25 is NOT 536.0575, would be if the values you are using in the calc are not exactly 21.23 or 25.25...again, a formatting issue that is only showing 2 decimal places, when the actual value has far more decimal places
Yes, this Round function is working. Thanks a lot
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks