How should the formula be, if I want cell A2 to be equals to cell A1 and at the time, checking if cell A1 is empty or not.
If cell A1 is blank, A2 will also be. If there are data in cell A1, A2 = A1.
Data from cell A1 is a word.
Based on my limited knowledge, I have tried using "orblank" function but is unable to print the data in cell A1 into A2.
Formula in cell A2:
=if(or(isblank(a1), " ", =A1))
Is there any way to resolve this issue?
Thanks in advance.