Help with creating an Excel Function

Question

I want to create an excel function where if I ask a question (from a drop down list of text responses) the response is as follows:

If "Yes" from the dropdown list then a number value of 20 is returned
If "No" from the dropdown list then a number value of 0 is returned
If "Unknown" from the dropdown list then a number value of 20 is returned
If "N/a" from the dropdown list then text is returned stating "Detail why N/a?"

I have done this:

=IF(C7="Yes",20,IF(C7="No",0,IF(C7="Unknown",20,IF(C7="N/a","Detail why N/a?","Not Scored"))))

but it doesnt seem to work.

detlef_lewin · Answer

Paul Rose&nbsp;wrote:&nbsp;but it doesnt seem to work.What makes you think that?&nbsp;&nbsp;

paul rose · Answer

When I change the drop down list from yes to no or n/a the value does not change. If I however I open the IF function in the cell and hit enter on the keyboard then it returns the right value. It's like it is not automatic

detlef_lewin · Answer

You have to set workbook calculation to "Automatic".

paul rose · Answer

Brilliant! That's worked. Thank you so much

Forum Discussion

Help with creating an Excel Function

Share

Resources