SOLVED

simple formula

Copper Contributor

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!!

5 Replies
... something like this?
=ROUNDUP(SUM(D2*1,53);0)
instead of hard coding 1,53 I would do it in another cell, more flexible
best response confirmed by CWVOC (Copper Contributor)
Solution

@CWVOC 

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?

@CWVOC 

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.

@CWVOC 

As @HansVogelaar mentioned just drag the cell with formula down (from D2 to D109), formula will be changed automatically in each next cell.

1 best response

Accepted Solutions
best response confirmed by CWVOC (Copper Contributor)
Solution

@CWVOC 

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.

View solution in original post