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
|
|||
|
|||
How to test a cell to see if it is over a threshold?
Hi,
I have a column with Sales figures in Column A for eg. 5000, 3000 etc and I need to indicated whether they are above the bonus target of 4500. Is there a formula I can create that would give me the results ON TARGET or Below Target next to the sales figures in Column B? Any help greatly appreciated Thanks in advance Janet |
#2
|
|||
|
|||
How to test a cell to see if it is over a threshold?
One way:
Assume your target amount is in D1. B1: =IF(A1=$D$1, "ON TARGET", "Below Target") Copy down as far as required. In article , Grd wrote: Hi, I have a column with Sales figures in Column A for eg. 5000, 3000 etc and I need to indicated whether they are above the bonus target of 4500. Is there a formula I can create that would give me the results ON TARGET or Below Target next to the sales figures in Column B? Any help greatly appreciated Thanks in advance Janet |
#3
|
|||
|
|||
How to test a cell to see if it is over a threshold?
Type your target number in C1, and enter this formula in B1, and copy down
as needed: =IF(A1=$C$1,"ON Target","Below Target") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Grd" wrote in message ... Hi, I have a column with Sales figures in Column A for eg. 5000, 3000 etc and I need to indicated whether they are above the bonus target of 4500. Is there a formula I can create that would give me the results ON TARGET or Below Target next to the sales figures in Column B? Any help greatly appreciated Thanks in advance Janet |
#4
|
|||
|
|||
How to test a cell to see if it is over a threshold?
That worked for me
Thanks "Grd" wrote: Hi, I have a column with Sales figures in Column A for eg. 5000, 3000 etc and I need to indicated whether they are above the bonus target of 4500. Is there a formula I can create that would give me the results ON TARGET or Below Target next to the sales figures in Column B? Any help greatly appreciated Thanks in advance Janet |
#5
|
|||
|
|||
How to test a cell to see if it is over a threshold?
Thanks
Works! "RagDyeR" wrote: Type your target number in C1, and enter this formula in B1, and copy down as needed: =IF(A1=$C$1,"ON Target","Below Target") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Grd" wrote in message ... Hi, I have a column with Sales figures in Column A for eg. 5000, 3000 etc and I need to indicated whether they are above the bonus target of 4500. Is there a formula I can create that would give me the results ON TARGET or Below Target next to the sales figures in Column B? Any help greatly appreciated Thanks in advance Janet |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell text based on 4 condition test | Bob Wall | Worksheet Functions | 3 | November 16th, 2005 08:34 PM |
hpw do I logic test a cell then copy the row to diff. SS | Debi | Worksheet Functions | 4 | October 5th, 2005 09:42 PM |
Possible Lookup Table | Karen | Worksheet Functions | 5 | June 8th, 2005 09:43 PM |
Union query with left join | Abdula Zakaria via AccessMonster.com | Running & Setting Up Queries | 4 | April 23rd, 2005 11:58 AM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 08:16 PM |