Rounding Functions Explained

0

waklert 50 price In FileMaker there are a few different rounding functions that you may want to consider. Each one is different, but with some similarities. Read below to see the rounding functions explained. The information is taken from the FileMaker help site.

Ceiling

Purpose

phenergan over the counter uk Returns a number rounded up to the next integer.

Format

cyclomune eye drops price Ceiling(number)

Parameters

dostinex uk price number – any numeric expression or field containing a numeric expression

Floor

Purpose

buy super kamagra 160mg Returns a number rounded down to the next lower integer.

Format

lisinopril walmart price Floor(number)

Parameters

letroz tab price number – any numeric expression or field containing a numeric expression

Int

Purpose

kamagra oral jelly price in kenya Drops digits to the right of the decimal point and returns the integer part of a number without rounding.

Format

voveran emulgel price in india Int(number)

Parameters

extra super p force uk number – any numeric expression or field containing a numeric expression

Round

Purpose

ventolin price Returns a number rounded to the specified precision (number of decimal places).

Format

Round(number;precision)

Parameters

number – any numeric expression or field containing a numeric expression
precision – any numeric expression or field containing a numeric expression

Description

If you round a negative number of decimal places, all digits to the right of the decimal point are dropped, and the number is rounded to the nearest tens, hundreds, and so on. The Round function always rounds up at 0.5.

Truncate

Purpose

Returns a number truncated to the specified number of decimal places.

Format

Truncate(number;precision)

Parameters

number – any numeric expression or field containing a numeric expression
precision – any numeric expression or field containing a numeric expression for the number of decimal places.

Description

This function doesn’t evaluate digits beyond the specified precision. Use the Round function to round up or down to the required precision.

 

Results Comparison

atarax canada Number livial side effects uk Ceiling ( Number ) celadrin walmart canada Floor ( Number ) kamagra jelly buy online Int ( Number ) terramycin la price Round ( Number ; 0 ) minocin price Truncate ( Number ; 0 )
metaspray nasal spray price in india 20.3 21 20 20 20 20
retin a cream uk ebay 0.5 1 0 0 1 0
luvox online purchase 56.2 57 56 56 56 56

 

Free Download

Download this little FileMaker database to see the calculations at work. A great example for beginners!

Download “Rounding Functions” Rounding-Functions.zip – Downloaded 62 times – 289 KB

Leave a Reply