I have a problem with my nested if condition as an Excel formula. I know it would be easier by using VBA, but I have to do it this way.
This is my formula, but it returns FALSE: =IF(D:D="SUPER";IF(AND(AA:AA="0";AA:AA="1");"V";IF(AA:AA="3";"R";"O")))
The D:D column has 3 filters, I have to apply the same formula with each filter. The AA:AA column has the following conditions: - if 0 and 1 -> V - if 3 -> R - if anything else -> O
I don't know why it doesn't work, but I would appreciate any advice!
Aucun commentaire:
Enregistrer un commentaire