How to correctly write a cross-sheet "IF" formula in Excel
 

I am trying to write a formula that will copy a cell or group of cells from
one sheet to another based on a null value. Here is the formula I am trying...

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

"FAIR" is the sheet where the data is stored, and if not null("") in a
specific cell, I want to copy portions of the row into a new row on a new
sheet called "Disposition".
Seems like it should be simple, but I am having a heck of a time.

THANKS!

How to correctly write a cross-sheet "IF" formula in Excel
 

=IF(FAIR!M6="","",FAIR!A6,IF(FAIR!N6="","",FAIR!A6 ))
try this to start

How to correctly write a cross-sheet "IF" formula in Excel
 

This results in an error, "too many arguments".

Do you have any more ideas?

"damorrison" wrote:

=IF(FAIR!M6="","",FAIR!A6,IF(FAIR!N6="","",FAIR!A6 ))
try this to start

How to correctly write a cross-sheet "IF" formula in Excel
 

Inferring from your orig post:
=IF(FAIR!M6"","",FAIR!A6,IF(FAIR!N6"","",FAIR!A6))

Not very sure, but maybe you're looking for:
=IF(OR(Fair!M6="",Fair!N6=""),Fair!A6,"")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

How to correctly write a cross-sheet "IF" formula in Excel
 

I am not sure what you mean by "I want to copy portions of the row
into a new row on a new
sheet called "Disposition". "
What does that mean "portions of the row"?