Roundup within an IF statement after a condition is met.

[Marshal_au]

Hi Everyone,
I'm new to this group and not well trained with Excel, I've spent my morning looking at formulas trying to find the solution.
Here is the formula I have written, which works. I need to show a value of 7 if Z2 is less than 0.5, but I need it to roundup Z2 to the next whole number, if its greater than 0.51.
The rounding needs to happen before its multiplied by 1.89 as it is a freight charge per KG.

=IF(Z2<=0.5,"7",(Z2*1.89)+11.52)

If this can't be done, Z2 is currently =MAX(R2,S2)
Is it possible to have this cell roundup if the result is greater than 0.51?

Thanks in advance.
Marshal J.

 

[Michael M]

Maybe this

=IF(Z2<=0.5,7,ROUNDUP(Z2,)*1.89+11.52)

 

[Marshal_au]

Maybe this

=IF(Z2<=0.5,7,ROUNDUP(Z2,)*1.89+11.52)

Michael, you are a champion, that works perfectly. Thank you so very much!!

 

[Michael M]

glad to help...and thx for the feedback..