FM - A More Elegant Way of Rounding Up?

Is there a more elegant way to always round up than what I've done below?

Round (
SizeSqFt * ( TaxPerSqFT / 12 )
+ If ( IsEmpty ( TaxPerSqFT ); 0 ; .5 )
; 0 )
LVL 2
rvfowler2Asked:
Who is Participating?
 
Will LovingConnect With a Mentor PresidentCommented:
So your goal is to alway have it round up, regardless of how tiny the overage is? For example, if SizeSqFt * ( TaxPerSqFT / 12 ) = 600.00001, you want that to round to 601?

To always round up, use the following:

Round ( SizeSqFt * ( TaxPerSqFT / 12 )  + 0.499999 ; 0 )

See this FM Knowledgebase article for information on the Round() function as well as always rounding up or down.

http://help.filemaker.com/app/answers/detail/a_id/5233/
0
 
rvfowler2Author Commented:
Thanks, read the article, it also helps with other types of rounding.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.