I want to enter several conditions but Excel shows the message "you've entered too many arguments for this function". What I want to do is:
- If AD4 and U4 are equals then enter "xxx"
- Second: If AD4 is blanks but not U4 then enter "xxx"
- Third: If U4 is blank but not AD4 then enter "xxx"
Could you please help me with this?
=IF(AD4=U4,"REMOVE, RELOAD AND ALREADY PROCESSED UNDER BOTH DUNS", IF(ISBLANK((AD4),IF(NOT(ISBLANK(U4),"REMOVE, RELOAD AND REVERSE KEYING", IF(ISBLANK(U4),IF(NOT(ISBLANK(AD4),"REMOVE AND RELOAD"))))))))