Forum Discussion

klou0056's avatar
klou0056
Copper Contributor
Jun 21, 2024

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...
  • dscheikey's avatar
    dscheikey
    Jun 21, 2024

    klou0056 

    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).

     

Resources