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

J

Jay

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
 
B

Bob Phillips

Do you mean

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

and copy across

--

HTH

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

Jay

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

Max

Just a 2nd guess on this, from the earlier attempt in your earlier post:
=IF(OR(Fair!M6="",Fair!N6=""),"",Fair!A6)
 
B

Bob Phillips

I think Max means AND not OR

--

HTH

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

Max

I think Max means AND not OR
Click to expand...

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.
Click to expand...

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

Bob Phillips

Hi Max,

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

Bob
 
M

Max

Bob Phillips said:
I was careful to put 'think' as the OP wasn't absolutely clear,
but on the balance AND seemed more probable :))
Click to expand...

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
 
Top