Hello,


After a calculation i have a result and near it i need a comment.
If result is greater than expected comment is "To High"
If result is less than expected comment is "To Low"
And if is equal to expected comment is "Good Work"
I know how to get right or wrong with IF an conditional formating,
but i don't know how to get high and to low comment.

THANX

Suppose the value you want to test is in A1 and 'Good Work' is anything that falls between 40 & 60. For that, you could use a formula like:
=IF(A1>60,"Too High",IF(A1<40,"Too Low","Good Work"))

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank You,

With little modification, IT WORKS.
I think it was related with regional settings.
, replaced with ;
Thank you once again