Forum Discussion

Reaperzxz's avatar
Reaperzxz
Copper Contributor
May 11, 2023

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)        ...
excel
Excel for web
Formulas and Functions
Ivy_Rezzaghi's avatar
Ivy_Rezzaghi
Copper Contributor
May 11, 2023

Reaperzxz 

 

Hello!

 

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

I hope I've helped!

 

  • Reaperzxz's avatar
    Reaperzxz
    Copper Contributor
    May 11, 2023

    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 😅

     

    Kind regards,

     

    Reaperzxz

Resources