Forum Discussion
If formula "Logical Test" not working properly
I have been working on a excel form that has a list/drop down selections (B74): 1. Yes 2. No 3. Not assessed 3. Declined to answer If drop down option "Yes" is selected, new text will appear ...
What you see in the part highlighted in yellow depends on the actual value of B74 when you create the formula.
If B74 happens to contain yes at that moment, B74="yes" will evaluate to TRUE.
But if B74 contains anything else, such as no or Boris Johnson or 37, B74="yes" will evaluate to FALSE.
HansVogelaar thanks for the reply!
Based on your theory, I have selected B74="No" bit it still stays at false when I go and create a formula. The formula is accepted (no error notification) but it does not function at all like it normally does.
I've opened up a new excel spreadsheet and the same issue happens too. I've never had an issue until today.
Does B74 really contain only "No" or are there spaces before or after the word "No"?
- That seemed to do the trick! Didn't realize there was a space. Thank you for your time 🙂