SOLVED

# Can someone assist me with this excel formula

Copper Contributor

# Can someone assist me with this excel formula

I have 4 cells, B2, C2, D2 and E2. "Y" is for "Yes". "N" is for "No". to make this equation "Independent", B2 must be "N", C2 must be "N", D2 must be "N" and G2 must be "Y". Otherwise the equation will be "Not Independent".

Can Anyone share pls.

10 Replies

# Re: Can someone assist me with this excel formula

@chuahlm Try this:

``=IF(SUM(--(B2:E2={"N","N","N","Y"}))=4,"Independent","Not Independent")``

# Re: Can someone assist me with this excel formula

It gives #VALUE!. Why? What is wrong?

# Re: Can someone assist me with this excel formula

@chuahlm Have a look at the attached file and see which formulas work. Perhaps you need to enter the formula with C-S-E (ctrl shift enter) of you are not on MS365 or Excel 2021. That will enclose the formula in curly brackets { }

# Re: Can someone assist me with this excel formula

I opened you file to view your reply. When I remove the curly brackets { }, it will show #VALUE!

# Re: Can someone assist me with this excel formula

On which Excel version/platform you are?

# Re: Can someone assist me with this excel formula

MS365.

Forgot to mentioned that after downloading your version, when I changed any of the "Y" to "N", the changes do not take place. and vice versa when I changed the "N" to "Y" no changes take place.
I am confused. Pls assist. TQ.

# Re: Can someone assist me with this excel formula

The Microosoft Office Excel version that I am using is 2019. Hope that helps.
best response confirmed by VI_Migration (Silver Contributor)
Solution

# Re: Can someone assist me with this excel formula

Since you have Excel 2019, the formula will only work if you confirm it by pressing Ctrl+Shift+Enter each time you edit it.

# Re: Can someone assist me with this excel formula

to Hans Vogelaar, Sergei Baklan and Riny van Eeleken, TQVM for your assistance. Followed to the T and it worked!

# Re: Can someone assist me with this excel formula

Glad to know you sorted this out.

1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

# Re: Can someone assist me with this excel formula

Since you have Excel 2019, the formula will only work if you confirm it by pressing Ctrl+Shift+Enter each time you edit it.