HELP! me with IF function, with nested options.

[erbmitman]

Hi All,

There will be 7 resubmission status in cell N5, Q5, T5, W5, Z5, AC5 and AF5, it may D, C, B or A (which will be the last status) . If N5=D or C or B then get the status of Q5 so on and so forth till I get the final status of A. please help me, with this, I can make it with 2 status on either like A or B only but with 4 choices I don't know how to start the if formula.

Thanks for the help in advance.

[Pepe Le Mokko]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[windy58]

This will give you value of Q5 if N5 is B,C or D

=IF(OR(N5="D",N5="B",N5="C"),Q5)

A sample workbook showing required outcome would help.

[windy58]

This will give you value of Q5 if N5 is B,C or D

=IF(OR(N5="D",N5="B",N5="C"),Q5)

A sample workbook showing required outcome would help.

[erbmitman]

Hi All,

Please find attached file. I hope I explained well in the sample sheet. I need to count the status how many A,B,C or D which is in the AB column.
The condition needs the final status so we can see that needs to be upgraded to Status "A" which is the final status.


thanks thanks.

[oeldere]

you need to explain under which conditions the letter needs to be changed.

in your example R4 = b U4 = B X4 = B

Why are they B and not e.g. A?

[erbmitman]

D - Rejected
C- Not Complied
B- Approved as Noted
A - Accepted

this sheet is an example of Drawing Log monitoring we are using in the site, lets say, I got status D in 1st submission, means I need to resubmit it till I get Status A. Either I will received D, C or B or A in the 1st submission. Now we need to monitor if the items are in which Status because there are some penalties imposed by our head department if the status is D.