lundi 13 juillet 2020

How to use If statement to transfer a cell value from sheet1 to sheet 2 in google sheets?

I just want to know if its possible to use the IF STATEMENT in google sheets by such algorithm as follows;

On Sheet1, from Cell A1, I have a value 'blue', and if the value inside the cell is blue, it should be transferred in Sheet2, I don't know if the syntax is correct, but it's something like this.

=if A1 VALUE(Blue) then TRANSFER to sheet2 else FALSE;

Just to interpret how should it work, but I know the code is wrong. Any help will be greatly appreciated guys.

Aucun commentaire:

Enregistrer un commentaire