Forum Discussion
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) ...
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)