Scribd
Upload
32 views5 pages

Video 12 Excel Functions

The document presents a table of employees with their names, departments, sales figures, and whether they achieved their targets. It includes additional calculations such as counts and conditional statements related to their performance. Overall, it highlights the performance metrics of various employees across different departments.

Uploaded by

Rahul Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
32 views5 pages

Video 12 Excel Functions

The document presents a table of employees with their names, departments, sales figures, and whether they achieved their targets. It includes additional calculations such as counts and conditional statements related to their performance. Overall, it highlights the performance metrics of various employees across different departments.

Uploaded by

Rahul Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

First Name Last Name Department Sales Target Achieved

Alice Smith HR 150 Yes


Bob Johnson IT 200 No
Charlie Brown Finance 180 Yes
David White IT 220 Yes
Eva Clark HR 170 No
Frank Taylor Finance 210 Yes
Grace Evans IT 230 Yes
Hannah Martin HR 160 No
Ivan Lee Finance 200 Yes
Jack Walker IT 190 No

Concat
Countif
if
Concat Concat New Concat 2 Countif Countif No
150Yes 150 Yes 150-Yes 6 4
200No 200 No 200-No
180Yes 180 Yes 180-Yes
220Yes 220 Yes 220-Yes
170No 170 No 170-No
210Yes 210 Yes 210-Yes
230Yes 230 Yes 230-Yes
160No 160 No 160-No
200Yes 200 Yes 200-Yes
190No 190 No 190-No
if If New Column
1 5
0 0
1 1
1 1
0 0
1 1
1 1
0 0
1 1
0 0
First Name Last Name Department Sales Target Achieved Nested If
Alice Smith HR 150 Yes 4
Bob Johnson IT 200 No 4
Charlie Brown Finance 180 Yes 0
David White IT 220 Yes 4
Eva Clark HR 170 No 4
Frank Taylor Finance 210 Yes 1
Grace Evans IT 230 Yes 4
Hannah Martin HR 160 No 4
Ivan Lee Finance 200 Yes 1
Jack Walker IT 190 No 4
7
4

You might also like