Forum Discussion
chuahlm
Nov 22, 2022Copper 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 wi...
- Nov 23, 2022
Since you have Excel 2019, the formula will only work if you confirm it by pressing Ctrl+Shift+Enter each time you edit it.
chuahlm
Copper Contributor
The Microosoft Office Excel version that I am using is 2019. Hope that helps.
HansVogelaar
Nov 23, 2022MVP
Since you have Excel 2019, the formula will only work if you confirm it by pressing Ctrl+Shift+Enter each time you edit it.
- SergeiBaklanNov 23, 2022MVP
Glad to know you sorted this out.
- chuahlmNov 23, 2022Copper Contributorto Hans Vogelaar, Sergei Baklan and Riny van Eeleken, TQVM for your assistance. Followed to the T and it worked!