IF function does not work correctly.

[Biju]

Hi,

Please see the attached image,if giving wrong value.Can some one will tell the reason.

A = IF(AND('Training Feedback'[Average Trainer Rating]>=1.0,'Training Feedback'[Average Trainer Rating]<2),"Need Drastic Improvement",IF(AND('Training Feedback'[Average Trainer Rating]>=2.0,'Training Feedback'[Average Trainer Rating]<3),"Need Improvement",IF(AND('Training Feedback'[Average Trainer Rating]>=3.0,'Training Feedback'[Average Trainer Rating]<4),"Good",IF(AND('Training Feedback'[Average Trainer Rating]>=4.0,'Training Feedback'[Average Trainer Rating]<5),"Very Good",IF('Training Feedback'[Average Trainer Rating]=5.0,"Excellent","Need Drastic Improvement")))))

[Zubair_Muhammad]

@Biju

You are duplicating the average trainer rating in the AND clause

  AND (
        'Training Feedback'[Average Trainer Rating] >= 1.0,
        'Training Feedback'[Average Trainer Rating] < 2
    ),

should be

  AND (
        'Training Feedback'[Average Trainer Rating] >= 1.0,
        'Training Feedback'[Total Rating] < 2
    ),

[Biju]

Hi @Zubair_Muhammad,

Thank you for the reply ,but here i dont need to use the column Total Rating.

[Zubair_Muhammad]

Hi @Biju

Ok

Check @pawel1 suggestion. Increase the decimal points of the average column

[pawel1]

that must be rounding issue.  All scores below 5.0 will be 'Very Good', even 4.9999