Answer:
Enter the following in D5:
=ROUNDUP((SUM(B5,B5)*C5),0)
Explanation:
Required
Add up B5 and B5, then multiply by C5.
Save result rounded up to 0 decimal places in D5
The required computation can be represented as:
D5 = (B5 + B5) * C5 <em>[Approximated to 0 decimal places]</em>
In Excel, the formula is:
=ROUNDUP((SUM(B5,B5)*C5),0)
Analyzing the above formula:
= ---> This begins all excel formulas
ROUNDUP( -> Rounds up the computation
(SUM(B5,B5) ---> Add B5 to B5
*C5) --> Multiply the above sum by C5
,0) ---> The computation is rounded up to 0 decimal places
To get the formula in D6 to D9, simply drag the formula from D5 down to D9.
The resulting formula will be:
=ROUNDUP((SUM(B6,B6)*C6),0)
=ROUNDUP((SUM(B7,B7)*C7),0)
=ROUNDUP((SUM(B8,B8)*C8),0)
=ROUNDUP((SUM(B9,B9)*C9),0)
