SheetSkill

FISHERINV function

Inverse Fisher transformation.

Syntax

=FISHERINV(y)

Arguments in [square brackets] are optional.

Try itType =FISHERINV( in E2 and click cells to fill in the arguments.
E2
Click a cell, then type. Right-click for rows, columns, sort and filter.
A
B
C
D
E
F
G
H
I
J
K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Item
Qty
Price
Date
Try here
Apples
12
$0.50
2024-01-15
Bananas
30
$0.25
2024-02-29
Cherries
8
$3.20
2024-04-30
Dates
15
$2.75
2024-07-27
Figs
5
$1.90
2024-12-01

Conditional formatting

A number, or a cell like =$H$1

AaBbCc 123

Rules on this sheet (0)

No rules yet. When several rules affect the same cell, the one higher in this list wins.

Find and Replace

Edit chart

Create Table

A table gets a name, coloured rows, filter buttons and grows by itself when you type in the row below it. Formulas can then say =SUM(Table1[Sales]) instead of =SUM(D2:D20).

Go To

Format Cells

Sample1234.5

No specific number format.

Insert Hyperlink

A cell reference like Sheet2!A1 links to a place in this workbook. Ctrl+click a link cell to open it.

New note · E2

Notes show as a red corner. Ctrl+Enter saves.

Insert Function

SUM(number1, [number2], …)
Adds numbers