+2Hi,
I’m trying to roundup the following formula: ({GROUP PRICE}+({EXTRAS}*3))/3
Where GROUP PRICE is the pricing for a group to which I add extras * by number of guests and then divide by 3 to obtain a price per person. The formula is working and in this case I obtain a pricing of 101.667€. I’m trying to roundup this number to 102€.
Thanks
+28Hey
You’ll want to give the following formula a shot:
CEILING(({GROUP PRICE} + ({EXTRAS} * 3)) / 3)
Works on my side!
Mike, Consultant @ Automatic Nation
+28Did it work
+31Can try ROUNDUP too
ROUNDUP(
({Group Price}+({Extras}*3))/3,
0
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.