| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Function to test formula in a cell | Excel Worksheet Functions | |||
| Logical Test comparison using cell color | Excel Discussion (Misc queries) | |||
| hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Threaded Mode
