Thread: [Solved] Force the decimals to even numbers in a formula
View Single Post
 
Old 01-22-2024, 05:35 PM
Marcia's Avatar
Marcia Marcia is offline Windows 11 Office 2021
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Quote:
Originally Posted by ArviLaanemets View Post
How much are taxes? 2% or 20%?

Taxes is 2% but the 20% I gave is an example of accumulated fines.

About CEILING() parameter - the result is rounded up, so it will be ending as multiply of parameter. So with parameter = 0.02, the results will be either ?.00, ?.02, ?.04, etc.
Thank you on this. I did some reading on the parameters and got an appreciation of the CEILING function.
Reply With Quote