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]
|