Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Functions
I have been racking my brain trying to write a function that will assist with
with one my daily reports. I'm hoping someone can point me in the correct direction. I have a workbook that tracks the contacts that my dpt receives weekly and dpt members are required to log the contacts under the appropriate bucket. My workbook allows me to take the entered information and change the Bucket (Column D) if it is incorrect. so the basic if function would be =IF(,"N","Y"). The arugment that I want to test, is if for example D2 has to be modified in anyway (ie- I have to correct the bucket that the contact is in) then the cell in column G populate with an N, if no changes are made to cell D2 then cell in column G populates to Y. Any thoughts? St |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions |