Learn More Excel Functions
ProComp Solutions Ltd, Holme Farm Cottage, 15 Woad Lane, Great Coates, Grimsby, North East Lincolnshire,
DN37 9NB – Tel: 01472 321703 or 07812 456820 – Email: enquiries@procompsolutions.co.uk
Date and Time
NOW =NOW() Date and time (21/10/99 10:56)
TODAY =TODAY() Date (21/10/99)
WEEKDAY =TEXT(WEEKDAY(DATEVALUE(“21/10/99”)),”dddd”) Day of the date (Thursday)
Information
INFO =INFO(“directory”) Path of the current folder
ISERROR =IF(ISERROR(C4),,C4) Only displays contents of cell C4 if it
does not contain an error
ISEVEN =ISEVEN(3) Displays FALSE if the number is odd,
TRUE if even *
COUNTBLANK =COUNTBLANK(E4:E6) Displays the number of blank cells in the
range
Logical
IF =IF(B4<10,”OK”,”Over budget”) If B4 is less than 10 display “OK”
otherwise display “Over budget”
AND =IF(AND(B4>1,B4<50),B4,) Displays B4 only if it is greater than 1
AND less than 50
OR =IF(OR(B4>100,B4=10),B4,) Displays B4 if it is either greater than 100
OR equal to 10
Lookup and Reference
LOOKUP =LOOKUP(E2,B2:H2,B3:H3) Looks up E2 in B2:H2 and displays the
equivalent cell in B3:H3
HYPERLINK =HYPERLINK("http://www.microsoft.com","Click here") The words “Click here” hyperlink to the
Microsoft web site
Maths and Trigonometry
COUNTIF =COUNTIF(A1:B12,">10") Counts the number of cells in A1:B12
that are greater than 10
PI =PI() Returns pi to 15 decimal places
POWER =POWER(5,3) Calculates 5 to the power of 3
RAND =RAND() Returns a random number between 0 and
1
RANDBETWEEN =RANDBETWEEN(1,100) Returns a random number between 1 and
100 *
ROMAN =ROMAN(1999) Converts 1999 to roman numerals
(MCMXCIX)
Statistical
SMALL / LARGE =SMALL(A1:B2,3)
=LARGE(A1:B2,3)
Displays the 3rd smallest / largest value
in the range A1:B2
Text
LOWER / UPPER =LOWER(“JASON”)
=UPPER(“Jason”) Converts text to lower case or upper case
PROPER =PROPER(“JASON”) Converts text to proper case (Jason)
* These functions are from the Analysis ToolPak. (Add this by choosing Add-Ins… from the Tools menu)
Docsity.com
