| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't get a formula to work in each row of an Excel sheet. | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions | |||
| make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Threaded Mode
