Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: automatic text copying

  1. #1
    Guest

    Default

    I would like to do something like the following:

    type in some text in A1
    have the text automatically be copied to cell g10

    I can do this using a formula, but it leaves a "0" in g10 if A1 is blank. I'd prefer not to have the "0" there. Is this possible?

    Thanks.

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This will help:
    =IF(A1<>"",A1,"")

    It works like this:
    IF cell A1 is not equal (<>) to nothing ("") show A1 otherwise show nothing ("")

    I recommend using the IF function for many things it's extremely usefull.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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