| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Labeling results
Amazing - Thanks Trevor
Regards Gene "Trevor Shuttleworth" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Labeling results
You're welcome. Thanks for the feedback
"Gene L." wrote in message ... Amazing - Thanks Trevor Regards Gene "Trevor Shuttleworth" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Labeling results
Here is the formula:-
=IF(A11150,"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! "Gene L." wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Labeling X-Axis | Excel Discussion (Misc queries) | |||
| Y-labeling issue | Charts and Charting in Excel | |||
| Labeling Worksheets with pop up window | Excel Discussion (Misc queries) | |||
| X-axis labeling | Charts and Charting in Excel | |||
| Data Point labeling | Charts and Charting in Excel | |||
Linear Mode
