Hi all,
We have a spreadsheet that we use to mark people on their jobs.
There is a summary page and then a page for each employee with a template on, if they achieve a certain criteria there is a drop down box that give you a yes or a no, option, this word then appears in the cell. The yes or no is worth a % of a final score.
On the summary page I want to fetch that yes or no and then, depending on what is written print out the % in that cell so they can be added up at the end.
I figured the IF statement would be best to use:
=IF(Employee1!D8=yes, 10, 0)
In this case, the yes is worth 10% of their final score. I couldn't get it to accept the formula for ages and now it does i only get #NAME? appear in the cell.
Anyone any ideas what I am doing wrong? Is it the drop down box that is an issue?
We have a spreadsheet that we use to mark people on their jobs.
There is a summary page and then a page for each employee with a template on, if they achieve a certain criteria there is a drop down box that give you a yes or a no, option, this word then appears in the cell. The yes or no is worth a % of a final score.
On the summary page I want to fetch that yes or no and then, depending on what is written print out the % in that cell so they can be added up at the end.
I figured the IF statement would be best to use:
=IF(Employee1!D8=yes, 10, 0)
In this case, the yes is worth 10% of their final score. I couldn't get it to accept the formula for ages and now it does i only get #NAME? appear in the cell.
Anyone any ideas what I am doing wrong? Is it the drop down box that is an issue?
