Mar 10 2021 11:51 AM
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 below on (B75):
All my previous formulas have worked, but now if I write any new formula it's not working the way it usually does.
E.g. any NEW logical_test text I write automatically now sets to "= FALSE"
I have not changed any settings prior to this, so I am unsure what happened.
What I have tried:
Mar 10 2021 12:25 PM
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.
Mar 10 2021 03:00 PM
@Hans Vogelaar 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.
Mar 10 2021 03:16 PM
Does B74 really contain only "No" or are there spaces before or after the word "No"?
Mar 10 2021 03:24 PM