| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing an array formula
I have an array formula that I have set up. If certain criteria are not
found, I am getting an #N/A error (which is ok). Now I want to set up another formula that if there is something populated (which happens to be a number) in that cell that contains the array, I want that to populate otherwise I want it to reference a different cell. I tried using 1, but on the cells that contain #N/A, it will not reference the other cell. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referencing an array formula
Use ISNA function to test for error and take appropriate decision.
"Sh" wrote: I have an array formula that I have set up. If certain criteria are not found, I am getting an #N/A error (which is ok). Now I want to set up another formula that if there is something populated (which happens to be a number) in that cell that contains the array, I want that to populate otherwise I want it to reference a different cell. I tried using 1, but on the cells that contain #N/A, it will not reference the other cell. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referencing an array formula
Sh wrote:
I have an array formula that I have set up. If certain criteria are not found, I am getting an #N/A error (which is ok). Now I want to set up another formula that if there is something populated (which happens to be a number) in that cell that contains the array, I want that to populate otherwise I want it to reference a different cell. I tried using 1, but on the cells that contain #N/A, it will not reference the other cell. Any suggestions? =IF(ISNA(target),something else,target) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula referencing other worksheets | Excel Worksheet Functions | |||
| Referencing an array name | Excel Discussion (Misc queries) | |||
| Tough one - Sum and IF with multiple referencing (array) | Excel Worksheet Functions | |||
| #VALUE! On An Array Formula Referencing a Range Outside The Workbo | Excel Discussion (Misc queries) | |||
| referencing the value of a cell containing an array formula | Excel Worksheet Functions | |||
Linear Mode
