How to make a nested if?

I need to make a conditional with several yes, from two different columns, could you help me?

It would be best if you made a specific request, provided specific examples, and detailed the logic you’re trying to implement

5 Likes

I have two columns which are 4 digits in text format, so for example in column d I have 0310 and in column e I have 0110, I require that if it meets these criteria in column f everything that is different from 0221 is given to me. leave as 0240

Not sure I understand. If D=0310 and E=0110 you want change F to 0240?

This explanation is not clear.

Please provide a worked example.