Thread: [Solved] Force the decimals to even numbers in a formula
View Single Post
 
Old 01-21-2024, 05:31 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
In more recent versions of Excel:
Code:
=CEILING.MATH(D7,0.02)
and older versions:
Code:
=CEILING(D7,0.02)
where cell D7 is the result of your calculations, or the calculation itself instead of a cell reference.
Reply With Quote