writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 21:
Line 21: − + Line 27:
Line 27: + + + + + + + + Line 32:
Line 40: − + + Line 38:
Line 47: − + + + Line 44:
Line 55: − + + Line 50:
Line 62: − + + Line 56:
Line 69: − + + Line 62:
Line 76: − + + Line 70:
Line 85: − + − +
→Examples
== Examples ==
== Examples ==
Consider the following table with Stationary Items, Quantity, Price and Percentage Profit.
Consider the following table in Zcalci with Stationary Items, Quantity, Price and Percentage Profit.
<div id="4SpaceContent" class="zcontent" align="left">
<div id="4SpaceContent" class="zcontent" align="left">
{| id="TABLE2" class="SpreadSheet blue"
{| id="TABLE2" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f" |
| class="sshl_f" | A
| class="sshl_f" | B
| class="sshl_f" | C
| class="sshl_f" | D
|- class="odd"
| class="sshl_f" | 1
| class="sshl_f" | '''Item'''
| class="sshl_f" | '''Item'''
| class="sshl_f" | '''Quantity'''
| class="sshl_f" | '''Quantity'''
| class="sshl_f" | '''Profit'''
| class="sshl_f" | '''Profit'''
|- class="odd"
|- class="even"
| class="sshl_f" | 2
| class="sshl_f" | Pen
| class="sshl_f" | Pen
| class="sshl_f" | >10
| class="sshl_f" | >10
| class="ssh1_f" |
| class="ssh1_f" |
|- class="even"
|- class="odd"
| class="sshl_f" | 3
| class="sshl_f" | '''Item'''
| class="sshl_f" | '''Item'''
| class="sshl_f" | '''Quantity'''
| class="sshl_f" | '''Quantity'''
| class="sshl_f" | '''Profit'''
| class="sshl_f" | '''Profit'''
|- class="odd"
|- class="even"
| class="sshl_f" | 4
| class="sshl_f" | Pen
| class="sshl_f" | Pen
| class="sshl_f" | 12
| class="sshl_f" | 12
| class="sshl_f" | 2
| class="sshl_f" | 2
|- class="even"
|- class="odd"
| class="sshl_f" | 5
| class="sshl_f" | Pencil
| class="sshl_f" | Pencil
| class="sshl_f" | 20
| class="sshl_f" | 20
| class="sshl_f" | 1
| class="sshl_f" | 1
|- class="odd"
|- class="even"
| class="sshl_f" | 6
| class="sshl_f" | Books
| class="sshl_f" | Books
| class="sshl_f" | 25
| class="sshl_f" | 25
| class="ssh1_f" | 5
| class="ssh1_f" | 5
|- class="even"
|- class="odd"
| class="sshl_f" | 7
| class="sshl_f" | Pen
| class="sshl_f" | Pen
| class="sshl_f" | 30
| class="sshl_f" | 30
= 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,"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,4,A3:D7) : Calculates the product in the range A3 to D7, of all values in Profit column. ''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. <br>Returns '''40''' as a result.
==Related Videos==
==Related Videos==