Forum Discussion
Round up / down in calculated column
Hi I am trying to use a calculated column to round up or downs cash figures. I can achieve this easily in excel, I thought the formula would be similar just formatted to work with list column...
LukeSykes a seemingly simple request but actually very difficult to deliver and probably not possible in SharePoint alone. I think I can do it with a flow in Power Automate that's triggered by a JSON formatted button in the list, and I've got most of the way there. The bit I am slightly struggling with is the requirement to round up or down to the nearest 5 for the voucher rounding column. I'll look at this again over the weekend and hope to work out a solution for you.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Thats fantastic - thank you
Vouchers come in multiples of £5, so a £5 voucher, £10, £15, £20 and £25, so if the calculation comes to £9 is rounds up to £10, if it comes to £6 it rounds it back down to £5, however, if it comes to in the middle, like £23, then it would round back down to £20 not up to £25
I actually already have a flow that creates the list item so if it could be integrated into that that would be superb.