What is the formula to average two fields then round up?

Question

Hi All 
 I have two field in a product Min value and Max value. 
 I have the formula: 
 average($minimum_range_c,$maximum_range_c) 
 The Min amount is 376 and the max is 431 which works out as 403.5 but I need it to be 404 after rounding up. 
 I want to average these two values then round up. Is anyone able to help with this? Thanks again in advance. 
 
 Many thanks

Jaymie Raymond · Accepted Answer

Hi Jaymie Raymond , 
 does it work if you set the precision of the field to "0"? (the field might have the type decimal to get this propperty) 
 this should round accordingly 
 
 Edit: 
 if you want to use a formula instead it is 
 round(average($minimum_range_c,$maximum_range_c),0) 
 Bests 
 Bj&ouml;rn