Copy of Excel Calculations Sample by  psuthesan  psuthesan 
  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 language supports functions and mathematical operatorsSample Data Used Below:10
30
50
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)"
0
ROUND"=ROUND(1.6)"2
RAND"=RAND()"0.8615162774438398
TRUE"=TRUE() || FALSE()"true
FALSE"=TRUE() && FALSE()"
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
true
a <= b (less than or equal to test)"=100<=F3"
false
a == b (equal to test)"=F2==F3-20"true
true
a != b (inequality test)"=F2!=F3"true
true
a > b (greater than test)"=F2>F3"
false
a >= b (greater than or equal to test)"=F2>=F3"
false
!a (boolean not)"=!(F2 < 5)"true
true
a ? b : c (boolean if expression)"=F2 == 10 ? F3 : F4"30
30
(a + b) / c (parentheses for expression precedence)"=(F2 + F3) / F4"0.8
(This page was created as a Num Sum spreadsheet and published/exported as a HTML page.)
(This page was created as a Num Sum spreadsheet and published/exported as a HTML page.)
 
Average Rating:  Not rated (Not yet rated)
 
Name:  Copy of Excel Calculations Sample by  psuthesan psuthesan 
Description:  Num Sum supports functions like SUM, AVERAGE, COUNT and mathematical operators
Tags:  numsum help formula functions FAQ  
[ default color ]
 
 recent: