Labeling results

G

Gene L.

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.
 
T

Trevor Shuttleworth

In cell B1, put the formula:

=IF(A1>150, "Over","") and copy down

Regards

Trevor
 
T

trip_to_tokyo

Here is the formula:-

=IF(A11>150,"Over","")

A11 being the cell in which you have entered the information.

The above formula can be copied to other cells in column B to give you the
results for which you are looking.

Please hit Yes if my comments have helped.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing result color 2
Weighted average using SUMIF and/or SUMPRODUCT 3
Combine two different column charts 2
Returning 100% 1
negative number format 1
seeking a smarter lookup function 6
averaging data in multiple columns 6
summing data in multiple columns 4

Top