Combination of Data

[mmustkee]

Hi Team,

Could you please help me i n applying the formula "=IFERROR(IF(N5=Q5,"Dd",IF(Oo5=R5,"Rr","Ii")),"Dd")" for  the attached sheet?

Thanks in advance.

Thanks,

Mohammad Mustkeem

[pedrodrfaria · Accepted solution]

Hi @mmustkee 

I believe what you are trying to do would be this function below:

if isnull([N]) and isnull([Q]) and isnull([O]) and isnull([R]) then 'D' elseif
[N] = [Q] then 'D' elseif
[O] = [R] then 'R' else 'IN' endif

Please let me know if it does not work for you.

Pedro.

[mmustkee]

Great solution.

Thanks