Need help for multiple logicals/ nested logics if function

[tussitje]

Hi,

I'm currently developing a risk management tool where we assess each contracting partner. The partners will be financially assessed, then financially approved and we'll include a new financial revision date in the sheet.

I show the companies in one column, then if they have been financially assessed or not in another (Y or N), then in the next column if the finance has been approved (Y or N) (can only be approved if assessed). Then I've added a column where I've combined the two previous- 1 if assessed and approved, 2 if not approved, and 3 if not evaluated. Then I've included a column where I've added if a new financial assessment is needed (Y, N, N/A) (based on another column = if date is > than today(), then N, if smaller then Y, and if the company has not been approved or assessed then N/A. So now I've tried to make another column which will combine the one with the 1,2,3 and the one with the (Y,N/N/A). So my logics are as follows:

- if Assessed and approved financially and no financial assessment needed, then Approved
- if Assessed and approved financially and financial assessment needed, then Revision needed
- if Assessed but not approved, then Not approved
- if not assessed, then not evaluated

When I try to build this in the if function, it doesn't work, so I'm sure I've made a/some mistake(s). Can anyone help me. I'll include the excel sheet for better understanding.

[Sindhus]

Try this formula

=IF(AND(C8="Y",D8="Y"),IF(H8="N","Approved","Revision needed"),IF(C8="N","Not evaulated","Not approved"))

[tussitje]

Hi than you.

Seems like a good formula- only problem is that I get the message that I've entered too many arguments for this function.....

[Sindhus]

No clue. Check the attached file. The same formula in I column works correctly.

[tussitje]

Thank you!! Now it works! You made my day!

[Sindhus]

As per the forum rules, Please make this thread as solved, if your problem is resolved.