vendredi 23 juin 2017

(Excel) Using IF function to check 2 cells for input and returning a value based on result

I am creating a spreadsheet to check the name of a person completing a job and to check if they updated the database upon completion.

http://ift.tt/2tWBnYC

So if 'Alex' was to complete a job and update the database then return 1 to a cell. However if 'Alex' was to complete a job and not update the database then return 2 to a cell.

From this I want to get a percentage of how many times a person has or has not updated after completing a job

Appreciate all the help!

Aucun commentaire:

Enregistrer un commentaire