![]() |
|
#1
|
|||
|
|||
![]() 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 |
#2
|
||||
|
||||
![]()
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] |
#3
|
|||
|
|||
![]()
Thank You,
With little modification, IT WORKS. I think it was related with regional settings. , replaced with ; Thank you once again |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jschueller | Word | 1 | 08-20-2013 01:51 PM |
IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |
![]() |
pstein | Word | 2 | 03-31-2012 05:31 AM |
![]() |
Learner7 | Excel | 1 | 02-02-2011 03:16 AM |
![]() |
Dolfie_twee | Word VBA | 1 | 06-22-2010 07:54 AM |