UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Rounding The Decimal Number Only, Office 2013    
 
   
yassermatter
post May 1 2019, 12:58 PM
Post#1



Posts: 20
Joined: 7-March 16



I want to Rounding the decimal number only as show in column b by condition use round function
Attached File(s)
Attached File  Rounding_the_decimal_number_only2.zip ( 9.46K )Number of downloads: 6
 
Go to the top of the page
 
June7
post May 1 2019, 01:03 PM
Post#2



Posts: 597
Joined: 25-January 16



Cross post https://access-programmers.co.UK/forums/sho...ad.php?t=304906

--------------------
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 
RJD
post May 1 2019, 05:02 PM
Post#3


UtterAccess VIP
Posts: 9,641
Joined: 25-October 10
From: Gulf South USA


Hi: See if this gives you what you want ...

=IF(RIGHT(TEXT(A2,"0.00"),1)="5",ROUND(A2,1)-0.05,ROUND(A2,1))

HTH
Joe
Attached File(s)
Attached File  Rounding_the_decimal_number_only2_Rev1.zip ( 9.8K )Number of downloads: 2
 

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th June 2019 - 09:58 AM