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