Hi,
I have a number of nested IF formulas that aren't working and I feel like I've tried every variation but still can't craack it! Any help would be gratefully received!
SO in the cell next to the formula, I have 3 options and depending on what is selected, I then want it to generate a number.
So if 'Low' is chosen, the score is 1, if medium is chosen, the score is 2 and if high then the score is 3.
At the moment, my formula is this:
=IF(S4>="LOW","1",IF(S4>="Medium","2",IF(S4>="High","3")))
It generates correctly for Low and High but not medium! I'm not sure where I'm going wrong.
Thanks so much
I have a number of nested IF formulas that aren't working and I feel like I've tried every variation but still can't craack it! Any help would be gratefully received!
SO in the cell next to the formula, I have 3 options and depending on what is selected, I then want it to generate a number.
So if 'Low' is chosen, the score is 1, if medium is chosen, the score is 2 and if high then the score is 3.
At the moment, my formula is this:
=IF(S4>="LOW","1",IF(S4>="Medium","2",IF(S4>="High","3")))
It generates correctly for Low and High but not medium! I'm not sure where I'm going wrong.
Thanks so much