View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Gene L. Gene L. is offline
external usenet poster
 
Posts: 20
Default Labeling results

I am a new (and inexperienced) user of Excel Office 2007. On a worksheet I
have a set of daily values say between 50 and 450 in column A. My goal is to
remain under 150 each day, how can I set up a formula in column B to show
the word "Over" for each instance where the value exceeds 150? Can you help
me do this?
Thanks - Gene L.