hi to all experts....
hope all ill b fine......i need a help in excel for accurate digits may b its need formula....
Example : 25.235 i need jst 25.00
10.10 i need jst 10.00
100.985 i need jst 100.00 (even it is close to 101.000)
i need jst first 2 or 3 digits but after point i want to ignore that.
thanks in advance..........
Irfan Khan
Good morning.
Assuming your numbers start in A1 then in B1 put the formula and is pulled down, as you need.
=ΙΝΤ(Α1)
Regards
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Maybeyou mean
=INT(25.235)
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
thks all of you ......
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Hello
I think he's rounding the numbers to the nearest 5
If that's the case use:100.985 i need jst 100.00 (even it is close to 101.000)
or
Please Login or Register to view this content.
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks