How do I make this formula round the results to the next highest whole number?If the result is $345.16, I want it to round up to $346.00![]()
=SUM(I25*0.15)+I25
Same thing with this formula:
I know I use the ROUNDUP function, but I am not sure where to add it in this command string.![]()
=IF(H30=5%,SUM(I2:I13)*0.05,IF(H30=10%,SUM(I2:I13)*0.1,""))
Bookmarks