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