Forum Discussion
Help with creating an Excel Function
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 retur...
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
Brilliant! That's worked. Thank you so much