Associate
Im trying to create a spreadsheet but am having problems finding out hwo to do this one thing.
I have created a cell which has a list of two options yes or no. They are chosen via a drop down menu. I then want excel to choose a corresponding factor number to put in the cell next to this.
I would have thought the if function would be suitable but it doesnt like to use a text value in its logical_text box.
Any suggestions? I'm lost here
I have created a cell which has a list of two options yes or no. They are chosen via a drop down menu. I then want excel to choose a corresponding factor number to put in the cell next to this.
I would have thought the if function would be suitable but it doesnt like to use a text value in its logical_text box.
Any suggestions? I'm lost here