KEMBAR78
Excel Formulas | PDF
Scribd
Upload
11 views1 page

Excel Formulas

Uploaded by

Ali Minhas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views1 page

Excel Formulas

Uploaded by

Ali Minhas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Excel Formulas

Formulas
IF Logical test, ”if correct” ,”if wrong”
IF ERROR Value, “Error”/”Wrong”
Trim Select Value (remove space)
Proper First letter will become capital
Upper/Lower All letters become Upper/Lower
Len Shows total numbers of letters
Left/Right/Mid (Show left or right letters) Value, numbers of words eg:3,4,5
Concatenate (combine two or more cells) Cell 1, “space” Cell 2
Today date/ Current time Today() , Now()
EDATE (add months in date) Select the date cell, enter months to increase
Networks days Start date, End date, Holidays
Count/ Counta (for non-empty cells)/ Count blank Select the range
Count if Select the range, Write the word to be counted
Sum if Select the range, Write criteria
Sum ifs/ Average ifs Select sum/avg range, Criteria range 1, Criteria,
Criteria range 2, Criteria2
Count ifs Criteria range 1, Criteria 1, Criteria range 2,
Criteria 2

You might also like