Forum Discussion
CWVOC
Jul 12, 2023Copper Contributor
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...
- Jul 12, 2023
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.
HansVogelaar
Jul 12, 2023MVP
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.