How I need correct formula, that no t rounding?

T

TANDEX

Excel XP, my formula is =H45*0.18
It show value 237.57 (237.5694), but I need get 237.56 -without rounding, 2
first digits only.
How I need correct formula?

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What formula I should use: =ROUNDDOWN(H45*0.18;2) or =TRUNK(H45*0.18,2) ?? 2
Daily Time Sheets with Rounding 1
Need formula to round number up to always end in X.X9 6
Round formula 6
How to round & sum only the displayed (rounded) numbers 2
Rounding 4
Long "IF" formula 5
Error type mismatch in writing macro 2

Top