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