Reports

Excel formula functions supported by Red Sky Reports

Red Sky Reports presently supports the following list of formula functions. We will progressively be adding more Excel functions over time.
The functions are listed within categories, with these categories being listed in the following order:
Date and Time, Financial, Information, Logical, Lookup and Reference, Math and Trig, Statistical, Text and Data.
No links to other spreadsheets: there can be no calculations that link to other spreadsheets within a spreadsheet to be uploaded to Red Sky Reports.
Note re fonts: there are a limited number of fonts that can be used within spreadsheets to be uploaded to Red Sky Reports. These include:
Arial, Brush Script MT, Courier New, Garamond, Georgia, Tahoma, Times New Roman, Trebuchet MS, Verdana.

Date and Time functions

DATE
DATEDIF
DATEVALUE
DAY
DAYS360
EDATE
EOMONTH
HOUR
MINUTE
MONTH
NETWORKDAYS
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WORKDAY
YEAR
YEARFRAC

Financial functions

FV
IPMT
PMT

Information functions

ERROR.TYPE
ISBLANK
ISERR
ISERROR
ISEVEN
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISREF
ISTEXT
N
NA
TYPE

Logical functions

AND
FALSE
IF
IFERROR
NOT
OR
TRUE

Lookup and Reference functions

COLUMN
COLUMNS
HLOOKUP
HYPERLINK
INDEX
MATCH
ROW
ROWS
VLOOKUP
XLOOKUP

Math and Trig functions


ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATAN2
ATANH
CEILING
COMBIN
COS
COSH
DEGREES
EVEN
EXP
FACT
FACTDOUBLE
FLOOR
GCD
INT
LCM
LN
LOG
LOG10
MDETERM
MINVERSE
MMULT
MOD
MROUND
MULTINOMIAL
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SERIESSUM
SIGN
SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
TAN
TANH
TRUNC

Statistical functions

AVERAGE
AVERAGEA
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
DEVSQ
FISHER
GEOMEAN
MAX
MAXA
MEDIAN
MIN
MINA
STDEV
STDEVA
STDEVP
STDEVPA
VAR
VARA
VARP
VARPA

Text and Data functions

ASC
CHAR
CLEAN
CODE
CONCATENATE
DOLLAR
EXACT
FIND
FIXED
LEFT
LEN
LOWER
MID
PROPER
REPLACE
REPT
RIGHT
SEARCH
SUBSTITUTE
T
TEXT
TRIM
UPPER
VALUE

An unhandled error has occurred. Reload 🗙