Input |
Output | |
|---|---|---|
| D8 + D9 |
|
|
| SHEET1!D8+SHEET1!D9 | DSTCREATE(DST(SHEET1!D8)+DST(SHEET1!D9),"=SHEET1!D8+SHEET1!D9") | |
| CORREL(D8,D9) | CORREL(DST(D8),DST(D9)) | |
| COVAR(D8,D9) | COVAR(DST(D8),DST(D9)) | |
| DSTCREATE(IF(DST(D8)<D10,DST(D8),D10),"=IF(D8 SmallerThan D10,D8,D10)") | ||
| SUM(D8:D9) | DSTSUM(D8:D9,,"=SUM(D8:D9)") | |
| SUM(A5:A7) | SUM(A5:A7) | |
| PRODUCT(D8:D9) | DSTPRODUCT(D8:D9,,"=PRODUCT(D8:D9)") | |
| 2^D8 | DSTCREATE(2^DST(D8),"=2^D8") | |
| 2+SQRT(D8) | DSTCREATE(2+SQRT(DST(D8)),"=2+SQRT(D8)") | |
| 2+D8+D10 | DSTCREATE(2+DST(D8)+D10,"=2+D8+D10") | |
| D8 | DSTCREATE(DST(D8),"=D8") | |
| 2+D8 | DSTCREATE(2+DST(D8),"=2+D8") | |
| SQRT(D8) | DSTCREATE(SQRT(DST(D8)),"=SQRT(D8)") | |
| CORR(D8,D9) | CORR(DST(D8),DST(D9)) | |
| COVAR(D8,D9) | COVAR(DST(D8),DST(D9)) | |
| VAR(D8) | VAR(DST(D8)) | |
| AVERAGE(D8) | AVERAGE(DST(D8)) | |
| AVERAGE(D8:D9) | DSTAVERAGE(D8:D9,,"=AVERAGE(D8:D9)") | |
| AVERAGE(D8,D9) | DSTAVERAGE(D8,D9,"=AVERAGE(D8,D9)") | |
| SUMPRODUCT(D8:D9,A5:A6) | DSTSUMPRODUCT(D8:D9,A5:A6,"=SUMPRODUCT(D8:D9,A5:A6)") | |
| SUMPRODUCT(A6:A7,A5:A6) | SUMPRODUCT(A6:A7,A5:A6) | |
| D8*D9 | DSTCREATE(DST(D8)*DST(D9),"=D8*D9") | |
| (D8+D9)/(D8-D9) | DSTCREATE((DST(D8)+DST(D9))/(DST(D8)-DST(D9)),"=(D8+D9)/(D8-D9)") | |
| MIN(D8) | MIN(DST(D8)) | |
| MIN(D8:D9) | DSTMIN(D8:D9,,"=MIN(D8:D9)") | |
| MAX(D8,D9) | DSTMAX(D8,D9,"=MAX(D8,D9)") | |
| MAX(D8:D9) | DSTMAX(D8:D9,,"=MAX(D8:D9)") | |
| SUM(D8:D9) | DSTSUM(D8:D9,,"=SUM(D8:D9)") | |
| SUM(D8, D9) | DSTSUM(D8, D9,"=SUM(D8, D9)") | |
| MAX(D8,D9) | DSTMAX(D8,D9,"=MAX(D8,D9)") | |
| MAX(D8) | MAX(DST(D8)) | |
| D8+D10 | DSTCREATE(DST(D8)+D10,"=D8+D10") |