Consulting

Results 1 to 5 of 5

Thread: hiding data using other cells as reference

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    hiding data using other cells as reference

    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.
    Last edited by dhalls_supsu; 03-09-2012 at 01:29 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •