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