Is there a formula in LO Calc to even number to particular value. I have payments which are close to original value subtracted by some CC commissions so I would have Column B like
971.23
983.67
975.50
980
973.22
and I need to calculate VAT based on invoice value which is in this case 980 so I want to multiply B1*VAT% …
I know I could do an if
function, but I have 4 or 5 different values that needs to be rounded and they are not rounded like 1000 or 100. Technically I could do some ranges like if value +- 10 of 980 then 980, else if +-10 660 then 660
but just if statement would get very long