RoundUP formula help pls

[ashuk38]

hi guys

i have this formula in cell L12

=SUM(K12*$D$5)*24

Which displays overtime pay in currency format but need to roundup to the nearest penny. How can i roundup in the same cell, keeping the existing formula

I have attached in case anyone needs to look at what im trying to do.

new hours spreadsheet.xlsx

Thanks Guys

[FDibbins]

maybe this?

=ROUNDUP(SUM(K12*$D$5)*24,2)

[ashuk38]

Thanks buddy, worked a treat... Thank you so much its much appreciated..

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)