That works perfectly. Is there a way to add more elements to it though? I
also need it to include (in the same format) what the status would say if we
placed Accept in each of those cells. Whenever we placed Accept in any of
those cells it would all generate the same result "Closed". Is that possible
or would it contain to many factors for the function?

"Bob Phillips" wrote:

Is this what you want?

=IF(AS6="Reject","ALJ",IF(AK6="Reject","QIC",IF(AE 6="Reject","FI",IF(W6="Reject","RAC",""))))

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Ok... heres the detailed version then.

The column titles a

A6 = Claim Status
W6 = Accept / Reject
AE6 = Accept / Reject RAC Decision
AK6 = Accept / Reject FI Decision
AS6 = Accept / Reject QIC Decision

When:

W6 = Reject; A6 = RAC
AE6 = Reject; A6 = FI
AK6 = Reject; A6 = QIC
AS6 = Reject; A6 = ALJ

Currently the only one we can get to work is W6. The problem that we are
having is overriding the previous reject.

For example: We rejected the decision at the first level (W6) therefore
the
claim status is RAC. We have sent out an Appeal to the next level (AE6),
it
was upheld and we have rejected that decision... so now the Claim Status
should read FI (and so on).

What we don't want to have to do is manually change the Claim Status. We
would like it to automatically change to the correct level of Appeal based
on
when we reject the previous decision.

"Bob Phillips" wrote:

You are talking in very vague, general terms, whereas computers want
absolutes.

I am asking you to tell us what value in Cells W6, AE6, AK6, & AS6 will
determine what goes into the status column. Phrases like ... columns the
status will change to one of the following: RAC, FI, QIC, ALJ ... do not
clarify anything.

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Um.. I'm not sure what rules you mean. But we determine the status
based
on
the those columns below. If we place reject in those columns the
status
will
change to one of the following:
RAC, FI, QIC, ALJ

If we place accept in those columns the status will change to: Closed

"Bob Phillips" wrote:

What are the rules for determining the status?

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Hi,

I have a somewhat complicated question regarding how to apply a
function
under certain circumstances. Here's the situation:

I have a macro set up to color code the rows based on the
information
placed
in column A. However, I would like to eliminate the need to
actually
enter
anything into column A by placing a function (or Macro if possible)
into
the
rows of column A that will enter certain information when something
is
entered into another cell.

For example:

Cell A6 is what we call a Status Column... all it tells us is what
level
of
appeal the claim is in. Cell A6 is also the cell that the macro
corresponds
to in regards to our color coding. Cells W6, AE6, AK6, & AS6 are
where
we
get our information for the Status Column.

I need a function that will allow me to only have to enter
information
in
cells W6-AS6 that will automatically place the correct Status in the
status
column (at which point the macro will kick in and update the
coloring
on
the
spreadsheet).

Thanks :)