formula list by  kalaniku  kalaniku 
  Log In  |  Create a FREE Account  |  Everyone's Spreadsheets  |  Tags  |  Help  
 Saving... 
  login to save   undo redo  |  bold italic font text underline more font formatting  |  align left align center align right  |  text color background text color  |  sum hide/show tools
  fx
The Num Sum formula languageSample Data10
supports functions and30
mathematical operators50
Function NameExampleResult
SUM"=SUM(F2:F4)"90
AVERAGE"=AVERAGE(F2:F4)"30
COUNT"=COUNT(F2:F4)"3
MIN"=MIN(F2:F4)"10
MAX"=MAX(F2:F4)"50
ABS"=ABS(F3-F4)"20
CEILING"=CEILING(F2/F3)"1
FLOOR"=FLOOR(F2/F3)"
ROUND"=ROUND(1.6)"2
RAND"=RAND()"0.8987926314689921
TRUE"=TRUE() || FALSE()"true
FALSE"=TRUE() && FALSE()"
FIXED"=FIXED(1234.2345)"1,234.23
"=FIXED(1234.2345, 3)"1,234.2352nd argument is number of decimal places
DOLLAR"=DOLLAR(123.456)"$123.46Converts a number into a US currency string
N"=N(D21)"123.46N converts a value into a number
a * b (multiply)"=F2*F3*F4"15000
a / b (divide)"=F2/F3/F4"0.006666666666666666
a + b (add)"=F2+F3+F4"90
a - b (subtract)"=F2-F3"-20
a % b (modulo or remainder)"=F2 % F3"10
a < b (less than test)"=F2<100"true
a <= b (less than or equal to test)"=100<=F3"
a == b (equal to test)"=F2==F3-20"true
a != b (inequality test)"=F2!=F3"true
a > b (greater than test)"=F2>F3"
a >= b (greater than or equal to test)"=F2>=F3"
!a (boolean not)"=!(F2 < 5)"true
a ? b : c (boolean if expression)"=F2 == 10 ? F3 : F4"30
(a + b) / c (parentheses for expression precedence)"=(F2 + F3) / F4"0.8
 
Average Rating:  Not rated (Not yet rated)
 
Name:  formula list by  kalaniku kalaniku 
Description:  Num Sum supports functions like SUM, AVERAGE, COUNT and mathematical operators
Tags:  formula  
[ default color ]
 
 recent: