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