| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
error in one cell and formula in other
I would like to write a formula referencing two cells that may have this
condition. One cell has an error in it (#num) and the other cell has a formula in it which meets the condition of making that cell blank. What I would like to have is an or() statement that if one of these condition the or statement is true. I have one half of the problem done using iserror() but can't get the other half. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
error in one cell and formula in other
Try this:
=IF(OR(ISERROR(A1),B1=""),TRUE) Biff "wolfgangea" wrote in message ... I would like to write a formula referencing two cells that may have this condition. One cell has an error in it (#num) and the other cell has a formula in it which meets the condition of making that cell blank. What I would like to have is an or() statement that if one of these condition the or statement is true. I have one half of the problem done using iserror() but can't get the other half. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
error in one cell and formula in other
=IF(OR(ISERROR(A1),ISBLANK(B1)),[then],[else])
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "wolfgangea" wrote: I would like to write a formula referencing two cells that may have this condition. One cell has an error in it (#num) and the other cell has a formula in it which meets the condition of making that cell blank. What I would like to have is an or() statement that if one of these condition the or statement is true. I have one half of the problem done using iserror() but can't get the other half. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
error in one cell and formula in other
Hi wolfgangea,
maybe also like this =OR(ISERROR(C11),D11="") regards -- ***** birds of the same feather flock together.. "wolfgangea" wrote: I would like to write a formula referencing two cells that may have this condition. One cell has an error in it (#num) and the other cell has a formula in it which meets the condition of making that cell blank. What I would like to have is an or() statement that if one of these condition the or statement is true. I have one half of the problem done using iserror() but can't get the other half. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use vlook to show the value of a cell using a formula | Excel Discussion (Misc queries) | |||
| Is it possible? | Excel Worksheet Functions | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
