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

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

Parents Reply Children
No Data