AirSheets - Premium Spreadsheet Editor

Functions

Mathematical

SUM Add numbers

AVERAGE Calculate average

COUNT Count cells

MAX Find maximum

MIN Find minimum

ABS Absolute value

ROUND Round number

SQRT Square root

POWER Raise to power

PI Pi constant

RAND Random number

SIN Sine function

COS Cosine function

Logical

IF Conditional logic

AND Logical AND

OR Logical OR

NOT Logical NOT

IFS Multiple conditions

SWITCH Switch statement

Text

CONCATENATE Join text

LEFT Left characters

RIGHT Right characters

MID Middle characters

LEN Text length

UPPER Uppercase

LOWER Lowercase

TRIM Remove spaces

Date & Time

TODAY Current date

NOW Current date/time

DATE Create date

YEAR Extract year

MONTH Extract month

DAY Extract day

Lookup

VLOOKUP Vertical lookup

HLOOKUP Horizontal lookup

INDEX Get array value

MATCH Find position

Statistical

MEDIAN Middle value

MODE Most frequent

STDEV Standard deviation

VAR Variance

CORREL Correlation

PERCENTILE Percentile value

Financial

PMT Payment amount

PV Present value

FV Future value

NPV Net present value

IRR Internal rate of return

Information

ISBLANK Check if blank

ISNUMBER Check if number

ISTEXT Check if text

ISERROR Check if error

IFERROR Handle errors

All changes saved Just now

File Operation

Sheet Settings

Sheet Information

Grid Settings

Display Options

Default Cell Formatting

Number Formatting

Date & Time Formatting

Formula Calculation

Function Library

Mathematical Functions

Statistical Functions

Financial Functions

Text Functions

Date & Time Functions

Logical Functions

Sheet Protection

Cell Protection

Allowed Actions

Share Settings

Collaboration

Export Options