Skip to main content

Hi, 

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

Hey ​@Christophe33520,

You’ll want to give the following formula a shot:
 

CEILING(({GROUP PRICE} + ({EXTRAS} * 3)) / 3)

 
Works on my side!

Mike, Consultant @ Automatic Nation

Hi Mike,

great, thank you so much!

Did it work ​@Christophe33520? Please keep me posted :D

Can try ROUNDUP too

ROUNDUP(
  ({Group Price}+({Extras}*3))/3,
  0
)

 

Terms & Conditions