Labeling results
In cell B1, put the formula:
=IF(A1150, "Over","") and copy down
Regards
Trevor
"Gene L." wrote in message
...
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.
|