lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I will find the average salary using =average(D2:D8). What I also want to know the names of people who make more than average and the names who make more than average. How can I do that? Thank you
=average(D2:D8)
<tbody>
</tbody>
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
I will find the average salary using =average(D2:D8). What I also want to know the names of people who make more than average and the names who make more than average. How can I do that? Thank you
=average(D2:D8)
54787.57 |
<tbody>
</tbody>
name | dept | age | salary |
john1 | it | 46 | 99178 |
alex1 | hr | 38 | 13887 |
david1 | sales | 46 | 35365 |
mary1 | marketing | 72 | 13553 |
sam1 | it | 27 | 99579 |
linda1 | hr | 69 | 77583 |
john2 | sales | 67 | 44368 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>