Forum Discussion
Reaperzxz
May 11, 2023Copper Contributor
Use values from multiple cells from previous sheet in IF AND Formula
Dear Reader,
Can anyone help me with the following:
I want to show output true or false based on the values of 3 cells(A1,A2,A3) that are filled in from the previous tab(Tab_1)
So far I've tried this formula: =IF(AND(Tab_1!A1>=10,Tab_1!A2>=10,Tab_1!A3>=10),"TRUE","FALSE"). But it gives output "#NAME?".
Anyone that can help me with this? 🙂
Kind regards,
Reaperzxz
Since you use the Dutch version of Excel, you should use EN instead of AND. There is no need to use ALS (IF)
=EN(Tab_1!A1>=10,Tab_1!A2>=10,Tab_1!A3>=10)
If you use comma as decimal separator, it should be
=EN(Tab_1!A1>=10;Tab_1!A2>=10;Tab_1!A3>=10)
- Ivy_RezzaghiCopper Contributor
Hello!
I tried your formula and I changed all the "," for ";" and the results were TRUE / FALSE / FALSE.
I hope I've helped!
- ReaperzxzCopper Contributor
Thanks for your quick reply! 🙂
I tried your solution but I still don't get output "True" or "False"
The Formula I've got before gave me some (still wrong) output "#NAME?"
I'm pretty stuck on possible solution now to be honest 😅
Kind regards,
Reaperzxz