Can you help me combine these into one statement

IF Cell X= “EL” and Cell Y>=1,”EL”, “DC”) IF cell X =”NE” and >=2, “NEL”,”NES”)

By: mira

Can you help me combine these into one statement

IF Cell X= “EL” and Cell Y>=1,”EL”, “DC”) IF cell X =”NE” and >=2, “NEL”,”NES”)

By: mira

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Hi

Try this…

`=IF(AND(E1="EL",F1>=1),"EL",IF(AND(E1="EL",F1=2),"NEL","NES")))`

E1 represents your Cell X

F1 represents your Cell Y

I have assumed that if you want a response of “DC” then cells X must equal “EL” and cells Y must be less than 1. Please confirm if that assumption is correct. ðŸ™‚

Your assumption about DC is correct ….at the moment it isn’t returning “DC”

=IF(AND(J2=”EL”,Q2>=1),”EL”,IF(AND(J2=”EL”,Q2=2),”NEL”,”NES”)))

I have added the DC and everything has worked, Thanks