"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

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

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
>
>
>

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
--

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
> --
>
>

"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
--