FormCalc Question

Avatar

24-09-2008

Is there a way to use the Excel function of Ceiling in FormCalc? I need to multiply a number that rounds up to a multiplier of the sum of another field multiplied by 2 (=ceiling(x,(x*2)?



Thank you in advance

Replies

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

24-09-2008

The command in FromCalc is Ciel(n) where n is the number you want to operate on. It is well documented in the help.