Help with formula
How to make a percentage discount column in Apple Mac Numbers
I Want Column D to be the result of: Column C x .90 ( so Column D will be column C times .90 , or a 10% price reduction)
I want this to apply to rows 2 thru 79
How to do this? Thanks
MacBook Pro 15", macOS 10.14
Hi 747492WW,
In cell D2, type = to open the Formula Editor.
You can drag the Formula Editor by hovering the cursor over fX to the left to see the cursor change to a hand. Click and drag.
Click on C2.
Type *0.9
Numbers will change * to the multiplication symbol ×, not the same as a lower case x.
Click on the green tick or press return to confirm the formula.
With D2 selected, hover the cursor over its bottom edge to see the yellow dot (the Fill Down handle).
Drag the yellow dot down as far as you need to fill the formula into those cells. The formula will automatically adjust for each row.
Regards,
Ian.
Hi 747492WW,
In cell D2, type = to open the Formula Editor.
You can drag the Formula Editor by hovering the cursor over fX to the left to see the cursor change to a hand. Click and drag.
Click on C2.
Type *0.9
Numbers will change * to the multiplication symbol ×, not the same as a lower case x.
Click on the green tick or press return to confirm the formula.
With D2 selected, hover the cursor over its bottom edge to see the yellow dot (the Fill Down handle).
Drag the yellow dot down as far as you need to fill the formula into those cells. The formula will automatically adjust for each row.
Regards,
Ian.
Thanks, very much
How to make a percentage discount column in Apple Mac Numbers
