New Contributor

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

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

3 Replies

# Re: Use values from multiple cells from previous sheet in IF AND Formula

Hello!

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

I hope I've helped!

# Re: Use values from multiple cells from previous sheet in IF AND Formula

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

# Re: Use values from multiple cells from previous sheet in IF AND Formula

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)