samedi 28 septembre 2019

IF function in Google Sheets

I need a function in a cell to say: Blank if Tab 1 A2 cell is blank and Tab 2 A2 is blank. If Tab 1 A2 isn't blank and Tab 2 is blank the cell says "Pending" and if Tab 1 A2 isn't blank and Tab 2 A2 isn't blank then the cell = Tab 2 A2.

I'm working on a Google Sheets that need to reference other cells across 2 tabs.

Here's the function I have at the moment:

=IF(A13<>""&'Import Processing'!A13<>"",'Import Processing'!A13,IF(A13<>"","Pending"))"))

At the moment it's just showing whatever is in Tab 2 A2, and not regarding if Tab 1 A2 is blank or not.

Aucun commentaire:

Enregistrer un commentaire