Forum Discussion
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 wi...
Since you have Excel 2019, the formula will only work if you confirm it by pressing Ctrl+Shift+Enter each time you edit it.
I opened you file to view your reply. When I remove the curly brackets { }, it will show #VALUE!
On which Excel version/platform you are?
- 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.- The Microosoft Office Excel version that I am using is 2019. Hope that helps.
Since you have Excel 2019, the formula will only work if you confirm it by pressing Ctrl+Shift+Enter each time you edit it.
