| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to correctly write a cross-sheet "IF" formula in Excel | Excel Worksheet Functions | |||
| Formula based on Len | Excel Discussion (Misc queries) | |||
| The { formula } type of formula | Excel Worksheet Functions | |||
| How to I use ** without Excel thinking I want to type a formula? | Excel Discussion (Misc queries) | |||
| formula based on format | Excel Discussion (Misc queries) | |||
Threaded Mode
