Round to two decimal places

[golfnutte]

How does one write the formula for Excel to do the following:

12.896X.60=7.738 and then round to the nearest cent, as in this example I want 7.738 to appear as 7.74

Thanks!!!

[VBA Noob]

Format the cell as currency

or

=ROUND(12.896*0.6,2)

VBA Noob

[shg]

=round(a1*b1, 2)

[vinkar123]

There are two other things you can choose if you incase need it in a scenario

Roundup(a1*b1,2) will always round up to the next integer
Rounddown(a1*b1,2) will always ignores any decimal value and retains the number to the resulted integer