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