"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

"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" wrote in message
...
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

"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" wrote in message
...
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

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

"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" wrote in message
...
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
--

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

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

--

HTH

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


"Max" wrote in message
...
"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
--

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

Hi Max,

I was careful to put 'think' as the OP wasn't absolutely clear, but on the
balance AND seemed more probable :-))

Bob


"Max" wrote in message
...
"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
--

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

"Bob Phillips" wrote:
I was careful to put 'think' as the OP wasn't absolutely clear,
but on the balance AND seemed more probable :-))

Thought your interp was correct, Bob.
It'll be good if the OP confirms this, of course <g

My mistake here earlier was that I had carried over too much
"legacy" from the OP's other, earlier post as to what was wanted.

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