Help with IF statement

[AL789]

Hello,

I need help writing an IF statement with multiple AND/OR conditions that will achieve the results listed in the numerator column of the attached file. I need the IF statement to capture the criteria listed in the sample file.

Any suggestions?

[#2 · Accepted solution]

@AL789 

That could be like 

=IF( (C2="Yes")*ISNUMBER(B2)*(D2=0),B2,IF( (C2="No")*ISNUMBER(B2)*ISNUMBER(D2),D2,"DKNS"))

in assumption that total number of unit couldn't be negative and if no one condition is met then "DKNS"" 

[#3]

Thank you! Are you able to write an if statement for the denominator column as well?

See attached for criteria and results needed.

[#4]

@AL789 

Perhaps 

=IF( ((C2="Yes")+(C2="No"))*ISNUMBER(B2)*ISNUMBER(E2),B2,"DKNS")