+ Reply to Thread
Results 1 to 9 of 9

"IF"- "THEN" type Formula based on Null value

Hybrid View

  1. #1
    Jay
    Guest

    "IF"- "THEN" type Formula based on Null value

    I have a file with two spread sheets used for First Article Inspection/ First
    Article Reports. I am trying to automatically load data from the inspection
    sheet to the report if the results of the inspection were out of tolerance.
    In other words, if a particlular cell is anything but an empty string, I want
    to move the data from that row to the second sheet. The following is an
    attempted formula for just one of the cells in the row on the report sheet.

    =IF(FAIR!M6:N6="","",FAIR!A6)

    "FAIR" is the First Arctilce Inspection Sheet.

    Can anyone guide me in completing this task

  2. #2
    Bob Phillips
    Guest

    Re: "IF"- "THEN" type Formula based on Null value

    Do you mean

    =IF(FAIR!$M6="","",FAIR!A6)

    and copy across

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Jay" <Jay@discussions.microsoft.com> wrote in message
    news:6029C25F-8B91-4B2F-84F7-67D3F5C7EC65@microsoft.com...
    > I have a file with two spread sheets used for First Article Inspection/

    First
    > Article Reports. I am trying to automatically load data from the

    inspection
    > sheet to the report if the results of the inspection were out of

    tolerance.
    > In other words, if a particlular cell is anything but an empty string, I

    want
    > to move the data from that row to the second sheet. The following is an
    > attempted formula for just one of the cells in the row on the report

    sheet.
    >
    > =IF(FAIR!M6:N6="","",FAIR!A6)
    >
    > "FAIR" is the First Arctilce Inspection Sheet.
    >
    > Can anyone guide me in completing this task




  3. #3
    Jay
    Guest

    Re: "IF"- "THEN" type Formula based on Null value

    The data is in both M6 and N6. If both of these are empty, it should do
    nothing, if they are populated, I want to copy the cells over. I had tried
    this for a single cell and it seemed to work, just not for two. (M6 is amount
    over tolerance N6 is amount under)

    "Bob Phillips" wrote:

    > Do you mean
    >
    > =IF(FAIR!$M6="","",FAIR!A6)
    >
    > and copy across
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "Jay" <Jay@discussions.microsoft.com> wrote in message
    > news:6029C25F-8B91-4B2F-84F7-67D3F5C7EC65@microsoft.com...
    > > I have a file with two spread sheets used for First Article Inspection/

    > First
    > > Article Reports. I am trying to automatically load data from the

    > inspection
    > > sheet to the report if the results of the inspection were out of

    > tolerance.
    > > In other words, if a particlular cell is anything but an empty string, I

    > want
    > > to move the data from that row to the second sheet. The following is an
    > > attempted formula for just one of the cells in the row on the report

    > sheet.
    > >
    > > =IF(FAIR!M6:N6="","",FAIR!A6)
    > >
    > > "FAIR" is the First Arctilce Inspection Sheet.
    > >
    > > Can anyone guide me in completing this task

    >
    >
    >


  4. #4
    Max
    Guest

    Re: "IF"- "THEN" type Formula based on Null value

    Just a 2nd guess on this, from the earlier attempt in your earlier post:
    =IF(OR(Fair!M6="",Fair!N6=""),"",Fair!A6)
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --



  5. #5
    Bob Phillips
    Guest

    Re: "IF"- "THEN" type Formula based on Null value

    I think Max means AND not OR

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Max" <demechanik@yahoo.com> wrote in message
    news:e3i$2ts6FHA.4084@TK2MSFTNGP10.phx.gbl...
    > Just a 2nd guess on this, from the earlier attempt in your earlier post:
    > =IF(OR(Fair!M6="",Fair!N6=""),"",Fair!A6)
    > --
    > Rgds
    > Max
    > xl 97
    > ---
    > Singapore, GMT+8
    > xdemechanik
    > http://savefile.com/projects/236895
    > --
    >
    >




  6. #6
    Max
    Guest

    Re: "IF"- "THEN" type Formula based on Null value

    "Bob Phillips" wrote
    > I think Max means AND not OR


    Thanks for the correction, Bob !

    Should have paid greater attention to the OP's lines:
    > The data is in both M6 and N6.
    > If both of these are empty, it should do nothing,
    > if they are populated, I want to copy the cells over.


    Corrected: =IF(AND(Fair!M6="",Fair!N6=""),"",Fair!A6)

    Or, with cell references fixed to point at cols M & N
    if the formula is to be copied across, and filled, then:
    =IF(AND(Fair!$M6="",Fair!$N6=""),"",Fair!A6)

    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --



+ 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