Forum Discussion
Solved
simple formula
I need help with a simple multiplication formula- for example, I need to multiply D2 x 1.53 and raised to the next whole $ amount to go into the E2 space. I need this to continue down through D109 a...
Since you use point as decimal separator: in E2:
=ROUNDUP(D2*1.53, 0)
(No need to use SUM)
Fill or copy down to E109.
Since you use point as decimal separator: in E2:
=ROUNDUP(D2*1.53, 0)
(No need to use SUM)
Fill or copy down to E109.
- thank you, this seems to work so far- i just have to change the D cell # every time. is there an easier way?
As HansVogelaar mentioned just drag the cell with formula down (from D2 to D109), formula will be changed automatically in each next cell.
If you select E2 (the cell with the formula), then drag the fill handle (the little square in the lower right corner of the selected cell) downwards, Excel will automatically change D2 to D3, D4 etc. in the cells below.
