Hi,
I was wondering if someone could help please?
The cells I am using are:
Cell O = Available Score
Cell P = Score
Cell S = Specific Score
I have the scenario where I am scoring questions in Cell O – however there may be times when these are not applicable. I have formatted Cell O to be a drop down so the text is always “n/a”. I want Cell S to calculate if Cell O is n/a then populate with a 0 else the value of Cell P should appear.
Thanks
Charmagne
I was wondering if someone could help please?
The cells I am using are:
Cell O = Available Score
Cell P = Score
Cell S = Specific Score
I have the scenario where I am scoring questions in Cell O – however there may be times when these are not applicable. I have formatted Cell O to be a drop down so the text is always “n/a”. I want Cell S to calculate if Cell O is n/a then populate with a 0 else the value of Cell P should appear.
Thanks
Charmagne