How to Multiply by rounded figure

E

Eean

New Member
Joined
May 26, 2010
Messages
44
Hi,
I'm trying to get excel to multiply a figure in a cell by rounded up figure in another cell.
I realise that in cell properties it is only displaying the number as a rounded figure rather than change the figure. Is there any way to do that?
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Sort by date Sort by votes
You can use the functions ROUND, ROUNDUP and ROUNDDOWN to your needs..

So you can have =A1*ROUNDUP(A2;0) to have cell A2 rounded up as a whole number.


HTH
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
Rounding Negative time to the nearest minute in Excel
Replies
4
Views
176
Scott Huish
Scott Huish
B
  • Solved
Need to add two sets of minutes with custom formatting and round
Replies
1
Views
104
bh24524
B
S
  • Solved
Rounding time
2
Replies
18
Views
703
felixstraube
F
F
  • Question
Rounding values to 2 decimel while keeping total 100%
2 3 4
Replies
38
Views
705
awoohaw
awoohaw
S
  • Locked
  • Question
A Different way to Calculate Ratios using GDC & or MIN ?
Replies
1
Views
67
Fluff
Fluff

Forum statistics

Threads
1,216,100
Messages
6,128,825
Members
449,470
Latest member
Subhash Chand

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top