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 and E109... Thanks!!
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.
- ... something like this?
=ROUNDUP(SUM(D2*1,53);0)
instead of hard coding 1,53 I would do it in another cell, more flexible
