IF Formula HELP

[Dannytt93]

Hello,

I am trying to create an IF Statement and i am struggling to get it to work. I have a basic knowledge but i think this is a bit too complex for me.

i am trying to get a table to fill out based on whether a user has completed a form

so =IF('Data Deposit'!A2=TEXT="NAME" Sheet4!),AND,('Data Deposit'!C2=DATEVALUE"22/02/2019),AND,('Data Deposit'!E4=TEXT=YES) enter text X in cell y

Any help would be great

Thanks

Dan

 

[AlanY]

you can just use the AND() function to grouped them together, i.e.

=if(and(conditions1, condition2,..etc),"X","")