+ Reply to Thread
Results 1 to 3 of 3

automatic filling in cells in excel

  1. #1
    CA user
    Guest

    automatic filling in cells in excel

    Is it possible to have a formula in one cell input data into another cell?

    For example, if I want my formula in B3 to read if B3 equals zero then C4
    will automatically be inputed with N/A.

    If is possible, how would you write the formula?

    Thanks for the Help!

  2. #2
    Anne Troy
    Guest

    Re: automatic filling in cells in excel

    In C4, type =IF(B3=0,"N/A")
    But you don't say what you want if it does NOT = 0.

    *******************
    ~Anne Troy

    www.OfficeArticles.com


    "CA user" <CA [email protected]> wrote in message
    news:[email protected]...
    > Is it possible to have a formula in one cell input data into another cell?
    >
    > For example, if I want my formula in B3 to read if B3 equals zero then C4
    > will automatically be inputed with N/A.
    >
    > If is possible, how would you write the formula?
    >
    > Thanks for the Help!




  3. #3
    Biff
    Guest

    Re: automatic filling in cells in excel

    Hi!

    >> Is it possible to have a formula in one cell input data into another
    >> cell?


    No, it doesn't work that way.

    What you would do is have a formula in cell C4 that tests cell B3 to see if
    it equals zero.

    Formula in C4:

    =IF(B3=0,"N/A","")

    This formula has 3 parts (called arguments) to it:

    A logical test: B3=0
    A value to return if the logical test is TRUE: "N/A"
    A value to return if the logical test is FALSE: ""

    Since you did not specify the value_if_FALSE argument, I assumed you might
    want the cell left blank if B3 does not equal zero. That's what the double
    quotes do: "".

    Also, an empty cell will evaluate to zero, so if cell B3 is empty:

    =IF(B3=0,"N/A","")

    Will evaluate to TRUE and return N/A.

    A more robust formula will test for both B3 not being empty and equalling
    zero at the same time:

    =IF(AND(B3<>"",B3=0),"N/A","")

    Biff

    "CA user" <CA [email protected]> wrote in message
    news:[email protected]...
    > Is it possible to have a formula in one cell input data into another cell?
    >
    > For example, if I want my formula in B3 to read if B3 equals zero then C4
    > will automatically be inputed with N/A.
    >
    > If is possible, how would you write the formula?
    >
    > Thanks for the Help!




+ 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