Hello,
I would like to request the addition of CEILING and FLOOR functions for the Workato formula library.
CEILING(number,[significance]): rounds a given number up to the nearest specified multiple.
e.g. CEILING(23.002) == 24; CELING(23.002,1) == 23.1; CEILING(23.0002,-2) == 30
FLOOR(number,[significance]): rounds a given number down to the nearest specified multiple.
e.g. FLOOR(23.002) == 23; CELING(23.002,1) == 23.0; CEILING(23.0002,-2) == 20
This is now supported. Check ceil and floor in formula mode.
Send us a ticket, we will try our best to assist you with your problem
MICHAEL STRICKLAND
[Formula] Ceiling and Floor
Hello,
I would like to request the addition of CEILING and FLOOR functions for the Workato formula library.
CEILING(number,[significance]): rounds a given number up to the nearest specified multiple.
e.g. CEILING(23.002) == 24; CELING(23.002,1) == 23.1; CEILING(23.0002,-2) == 30
FLOOR(number,[significance]): rounds a given number down to the nearest specified multiple.
e.g. FLOOR(23.002) == 23; CELING(23.002,1) == 23.0; CEILING(23.0002,-2) == 20