samedi 15 juin 2019

Why am I recieing a FALSE value instead of Specified Value on IF statement?

I am trying to assign each cell to a type based on what value they hold

The D83 value changes, for example, if I put D83 with a value of 4 I will get the value TYPE A, also when I put a value of 60 or above I get TYPE C. The problem is that when I type a value between 30-59 or value 30 or 59, I always get FALSE instead of TYPE B. Appreciate the help!

Current code/formula:

=if(D83<=29,"TYPE A", if(D83="30-59","TYPE B" , if(D83>=60, "TYPE C" )))

Aucun commentaire:

Enregistrer un commentaire