Forum Discussion
klou0056
Jun 21, 2024Copper Contributor
Nested IF and OR functions not returning correct values
I'm trying to set up an IF function to check data in a column and insert specific values in another. I've nested other OR and IF functions within it, but the data keeps returning true even if it is f...
- Jun 21, 2024
It looks good to me:
In older Excel versions you have to save this formula as a matrix formula.
Please have a look at the enclosed file to see if it works there (as it did for me).
klou0056
Jun 21, 2024Copper Contributor
dscheikey
Nice catch and thank you for the simplification. Unfortunately, the output still comes out as "CAT2" so it seems that something else is amiss.
Nice catch and thank you for the simplification. Unfortunately, the output still comes out as "CAT2" so it seems that something else is amiss.
dscheikey
Jun 21, 2024Bronze Contributor
It looks good to me:
In older Excel versions you have to save this formula as a matrix formula.
Please have a look at the enclosed file to see if it works there (as it did for me).
- klou0056Jun 21, 2024Copper ContributorAh yep, it's working now. Thank for the help!