writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 85:
Line 85: − + − +
→Examples
= 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==
==Related Videos==