Changes

8 bytes removed , 19:27, 10 October 2015

Line 85: Line 85: −

= DPRODUCT(A3:D7,"Profit",A1:B2) : Calculates the product of percentage profits of Pens in the range A3 to D7, for the cells with Quantity>10. ~~<br>~~Returns '''8''' as a result.

+

= DPRODUCT(A3:D7,"Profit",A1:B2) : Calculates the product of percentage profits of Pens in the range A3 to D7, for the cells with Quantity>10. Returns '''8''' as a result.

−

= DPRODUCT(A3:D7,4,A3:D7) : Calculates the product in the range A3 to D7, of all values in Profit column. ~~<br>~~Returns '''40''' as a result.

+

= DPRODUCT(A3:D7,4,A3:D7) : Calculates the product in the range A3 to D7, of all values in Profit column. Returns '''40''' as a result.

==Related Videos==

Swapna

writer

2,661

edits

Changes

Manuals/calci/DPRODUCT (view source)

Revision as of 19:27, 10 October 2015