DataSheet= Sheet1 Let's Look & Find [ Usage of --() or ()*1 ] | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
Used Formula ...(With Running MicrosoftExcel Ver 2003) If Pink Formula that is FormulaArray !!! WithOut {} Input Formula and Press Control+Shift+Enter | ||||
No | Addr' | If use below Formula, You'll Get Result as Right | Result | Etc |
1 | B2 | =RIGHT(A2,1) | 3 | |
2 | B2 His Formula Used This Cell -> B2:B5 | |||
3 | B6 | =SUM(B2:B5) | 0 | |
4 | B6 His Formula Used This Cell -> B6:D6 | |||
5 | B7:B12 | =RIGHT(A7:A12,1) Select All Range and Input Formula | 3 | |
6 | B13 | =SUM(B7:B12) | 0 | |
7 | B13 His Formula Used This Cell -> B13:D13 | |||
8 | B14 | =SUM(RIGHT(A7:A12,1)) | #VALUE! | |
9 | B15 | =SUM(RIGHT(A7:A12,1)) | 0 | |
10 | B16 | =SUMPRODUCT(RIGHT(A7:A12,1)) | 0 | |
11 | C2 | =RIGHT(A2,1)*1 | 3 | |
12 | C2 His Formula Used This Cell -> C2:C5 | |||
13 | C7:C12 | =RIGHT(A7:A12,1)*1 Select All Range and Input Formula | 3 | |
14 | C14 | =SUM(RIGHT(A7:A12,1)*1) | #VALUE! | |
15 | C15 | =SUM(RIGHT(A7:A12,1)*1) | 29 | |
16 | C16 | =SUMPRODUCT(RIGHT(A7:A12,1)*1) | 29 | |
17 | D2 | =--RIGHT(A2,1) | 3 | |
18 | D2 His Formula Used This Cell -> D2:D5 | |||
19 | D7:D12 | =--RIGHT(A7:A12,1) Select All Range and Input Formula | 3 | |
20 | D14 | =SUM(--RIGHT(A7:A12,1)) | #VALUE! | |
21 | D15 | =SUM(--RIGHT(A7:A12,1)) | 29 | |
22 | D16 | =SUMPRODUCT(--RIGHT(A7:A12,1)) | 29 | |
23 | G2 | =F2>150 | FALSE | |
24 | G2 His Formula Used This Cell -> G2:G4 | |||
25 | G5 | =SUM(G2:G4) | 0 | |
26 | G5 His Formula Used This Cell -> G5:I5 | |||
27 | G7:G11 | =F7:F11>150 Select All Range and Input Formula | FALSE | |
28 | G12 | =SUM(G7:G11) | 0 | |
29 | G12 His Formula Used This Cell -> G12:I12 | |||
30 | G13 | =SUMPRODUCT((E7:E11>150)) | 0 | |
31 | H2 | =(F2>150)*1 | 0 | |
32 | H2 His Formula Used This Cell -> H2:H4 | |||
33 | H7:H11 | =(F7:F11>150)*1 Select All Range and Input Formula | 0 | |
34 | H13 | =SUMPRODUCT((F7:F11>150)*1) | 2 | |
35 | I2 | =--(F2>150) | 0 | |
36 | I2 His Formula Used This Cell -> I2:I4 | |||
37 | I7:I11 | =--(F7:F11>150) Select All Range and Input Formula | 0 | |
38 | I13 | =SUMPRODUCT(--(F7:F11>150)) | 2 | |
. |