Loading ...
Loading ...
Loading ...
EN-35
The table below shows how some formulas may be modified automatically when a paste operation
is performed.
Modified Formulas
Spreadsheet Paste Operation* Excel
⫻ ⇔
`
⫼ ⇔
/
≠⇔
<>
>
⇔
>=
<
⇔
<=
Omitted multiplication sign
→
`
CellIf(
⇔
IF(
CellMin(
⇔
MIN(
CellMax(
⇔
MAX(
CellMean(
⇔
AVERAGE(
CellMedian(
⇔
MEDIAN(
CellSum(
⇔
SUM(
CellProd(
⇔
PRODUCT(
logab(#1,#2
⇔
LOG(#2,#1
#1
2
→
#1^2
#1
–1
→
#1^–1
#1!
⇔
FACT(#1)
#1
X
'#2
→
#2^(1/#1)
#1{#2
→
#1/#2
'#1
⇔
SQRT(#1)
3
'#1
→
#1^(1/3)
log #1
⇔
LOG10(#1)
ln #1
⇔
LN(#1)
e^#1
⇔
EXP(#1)
10
#1
→
10^#1
π⇔
PI()
E#n1
→
10^#n1
#n1E#n2
→
#n1`10^#n2
#1^#2
←
POWER(#1, #2)
sin #1
⇔
SIN(#1)
cos #1
⇔
COS(#1)
tan #1
⇔
TAN(#1)
sin
–1
#1
⇔
ASIN(#1)
cos
–1
#1
⇔
ACOS(#1)
tan
–1
#1
⇔
ATAN(#1)
sinh #1
⇔
SINH(#1)
cosh #1
⇔
COSH(#1)
tanh #1
⇔
TANH(#1)
Loading ...
Loading ...
Loading ...