+ Reply to Thread
Results 1 to 3 of 3

Cell focus help

  1. #1
    Registered User
    Join Date
    04-28-2010
    Location
    pakistan
    MS-Off Ver
    Excel 2003
    Posts
    1

    Cell focus help

    Hi..
    I have used a IF statment in A1 cell, now i need that if my IF statment get false, then i want to assign any value to cell C3, please tell me how is it possible?
    regards,

  2. #2
    Registered User
    Join Date
    03-28-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Cell focus help

    Hey maabdolat,

    You can put another if statement in C3. Like:

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.
    Warm regards,

    Shampoo Monkey

    If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above this post.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Cell focus help

    You didn't say what you wanted if A1 is True. Let's say you want C3 to be blank. Let's Assume (it sounds like) A1 is giving either "True" or "False" then you can use
    Please Login or Register  to view this content.
    Does that work for you?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1