View Single Post
 
Old 03-08-2014, 10:14 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote