+ Reply to Thread
Results 1 to 4 of 4

Need help (not sure how to explain in title)

  1. #1
    Registered User
    Join Date
    09-20-2005
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office365
    Posts
    53

    Need help (not sure how to explain in title)

    Okay, i have a forumla in C4 that pulls a number from A4 then does a calculation. is there anyway to make it so nothing shows in the C4 column unless or until something is put into column A4?

    i hope that makes sense. if not i'll try to describe it better.

  2. #2
    Registered User
    Join Date
    10-05-2005
    Posts
    19
    Use conditional formatting on C4 (Format menu bar, Coditional Formatting)

    IF Formula Is: =A4=""

    Format (Make cell invisible by making the font colour the same as the cell background colour)

  3. #3
    Mike
    Guest

    RE: Need help (not sure how to explain in title)

    something like this in C4
    =IF(A4>0,a4,"")

    "Plasma" wrote:

    >
    > Okay, i have a forumla in C4 that pulls a number from A4 then does a
    > calculation. is there anyway to make it so nothing shows in the C4
    > column unless or until something is put into column A4?
    >
    > i hope that makes sense. if not i'll try to describe it better.
    >
    >
    > --
    > Plasma
    > ------------------------------------------------------------------------
    > Plasma's Profile: http://www.excelforum.com/member.php...o&userid=27404
    > View this thread: http://www.excelforum.com/showthread...hreadid=475422
    >
    >


  4. #4
    David McRitchie
    Guest

    Re: Need help (not sure how to explain in title)

    C4: =If(ISBLANK(A4),"",formula)

    or if A4 just looks empty but may contain spaces
    C4: =IF(TRIM(A4)="","",formula)

    A cell with a formula will never be empty, so if you are trying to
    reduce your used cell range this is not the solution.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "Plasma" <[email protected]> wrote in message
    news:[email protected]...
    >
    > Okay, i have a forumla in C4 that pulls a number from A4 then does a
    > calculation. is there anyway to make it so nothing shows in the C4
    > column unless or until something is put into column A4?
    >
    > i hope that makes sense. if not i'll try to describe it better.
    >
    >
    > --
    > Plasma
    > ------------------------------------------------------------------------
    > Plasma's Profile: http://www.excelforum.com/member.php...o&userid=27404
    > View this thread: http://www.excelforum.com/showthread...hreadid=475422
    >




+ 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