| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Function Question??
Perfect!!! Thanks for all your help :)
"Bob Phillips" wrote: I think that this works =IF(OR(AS6="Accept",AK6="Accept",AE6="Accept",W6=" Accept"),"Closed",IF(AS6="Reject","ALJ",IF(AK6="Re ject","QIC",IF(AE6="Reject","FI",IF(W6="Reject","R AC",""))))) -- __________________________________ HTH Bob "akemeny" wrote in message ... Because of the way our spreadsheets work if W6 says Accept then there would be no data entered in any of the following cells. So we could end up having the following: Row 1: W6=Reject; AE6=Reject; AK6=Accept Row 2: W6=Accept Row 3: W6=Reject; AE6=Reject; AK6=Reject; AS6=Accept Row 4: W6=Reject; AE6=Accept But we wouldn't have any instances whe Row 1: W6=Accept; AE6=Reject Everything in our spreadsheet has a trickle effect. Each one of those columns has two options either Reject or Accept. If we Accept at any level then thats where that ends.. there won't be any data after that. "Bob Phillips" wrote: What would happen if AS6 said Accept and W6 said Reject (and vice versa)? -- __________________________________ HTH Bob "akemeny" wrote in message ... 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 :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2002 question for pick from list with autocomplete function | Excel Worksheet Functions | |||
| Question re Vlookup function within Excel. | Excel Worksheet Functions | |||
| excel 2003 IF function question | Excel Discussion (Misc queries) | |||
| Excel function question | Excel Worksheet Functions | |||
| Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Hybrid Mode
