|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 14th, 2009, 01:38 PM
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
October 14th, 2009, 01:59 PM
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
October 14th, 2009, 03:08 PM
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
October 14th, 2009, 07:35 PM
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
October 15th, 2009, 05:34 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
