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!!!
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!!!
Format the cell as currency
or
VBA Noob=ROUND(12.896*0.6,2)
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
=round(a1*b1, 2)
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
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks