Hi, I am trying to use the IF formula for some data. I want to designate them based on their grand total. If its within a certain range then it would be designated 1, 2. or 3. 1 being the highest.
For numbers around 50-70 I am getting an error. Here is the formula.
Grand Total =54
=IF(AK13<10,"3",IF(AK13>60,"2",IF(AK13>75,"1")))
Bookmarks