Use values from multiple cells from previous sheet in IF AND Formula

[Reaperzxz]

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

[#2]

@Reaperzxz 

Hello!

I tried your formula and I changed all the "," for ";" and the results were TRUE / FALSE / FALSE.

I hope I've helped!

[#3]

@Ivy_Rezzaghi 

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 :grinning_face_with_sweat:

Kind regards,

Reaperzxz

[#4]

@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)