Scribd
Upload
63 views6 pages

Excel Formulas for Data Analysis

This document contains 6 examples of Excel formulas: 1) rounds the average of a range of cells to 3 decimal places, 2) displays "TRUE" or "FALSE" depending on if a cell value is greater than or equal to 25, 3) finds the median value between a range of cells, 4) performs multiple calculations in one formula, 5) sums the values of two cells, and 6) displays different text depending on if the average of two cells is equal to 10.

Uploaded by

marvz
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
63 views6 pages

Excel Formulas for Data Analysis

This document contains 6 examples of Excel formulas: 1) rounds the average of a range of cells to 3 decimal places, 2) displays "TRUE" or "FALSE" depending on if a cell value is greater than or equal to 25, 3) finds the median value between a range of cells, 4) performs multiple calculations in one formula, 5) sums the values of two cells, and 6) displays different text depending on if the average of two cells is equal to 10.

Uploaded by

marvz
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

1.

ROUNDS THE AVERAGE OF


THE CELLS A16 TO D16 INTO
3 DECIMAL PLACES.
=ROUND(AVERAGE(A16:D16)
,3)

2. DISPLAYS TRUE IF THE


VALUE OF THE CELL A20 IS
GREATER THAN OR EQUAL TO
25 AND FALSE IF LESS THAN
25.
=IF(A20>=25,TRUE,FALSE
)

3. GIVES THE MIDDLE VALUE


BETWEEN THE CELLS AB12
AND AB24.
=MEDIAN(AB13:AB23)
4. ADDS 20 AND 10 WITH
THE DIFFERENCE OF 15 AND

7 AND RAISES THE RESULT


TH
TO 5 POWER.
=((20+10)+(15-7))^5
=(SUM(20,10)+(15-7))^5
5. GIVES THE TOTAL OF THE
CELLS A20 AND A25.

=SUM(A20,A25)
=A20+A25

Displays DURAN if the


average of cells A12 and D12
is not equal to 10 and
ESCARPE if it is equal to 10.
=if(average(A12,D12)<>10,
DURAN,ESCARPE)

You might also like