| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR nested function
I need to test a cell to see if the cell is blank or if the value is < 0.
Trying: =IF((OR(A2="",A2<0),1,0)) should return 1 if it is blank or less than 0 and 0 if cell contains a value 0. Keep getting an error. Can you tell me where I am going wrong? Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF and OR nested function
What error do you get?
-- Kind regards, Niek Otten Microsoft MVP - Excel "Jon M" wrote in message ... I need to test a cell to see if the cell is blank or if the value is < 0. Trying: =IF((OR(A2="",A2<0),1,0)) should return 1 if it is blank or less than 0 and 0 if cell contains a value 0. Keep getting an error. Can you tell me where I am going wrong? Thanks, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF and OR nested function
Hi,
It was a parenthesis problem =IF(OR(A2="",A2<0),1,0) or to take care of text =IF(OR(A2="",ISNUMBER(A2<0)),1,0) Mike "Jon M" wrote: I need to test a cell to see if the cell is blank or if the value is < 0. Trying: =IF((OR(A2="",A2<0),1,0)) should return 1 if it is blank or less than 0 and 0 if cell contains a value 0. Keep getting an error. Can you tell me where I am going wrong? Thanks, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF and OR nested function
great, thanks!
"Mike H" wrote: Hi, It was a parenthesis problem =IF(OR(A2="",A2<0),1,0) or to take care of text =IF(OR(A2="",ISNUMBER(A2<0)),1,0) Mike "Jon M" wrote: I need to test a cell to see if the cell is blank or if the value is < 0. Trying: =IF((OR(A2="",A2<0),1,0)) should return 1 if it is blank or less than 0 and 0 if cell contains a value 0. Keep getting an error. Can you tell me where I am going wrong? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested if function | Excel Worksheet Functions | |||
| Nested IF Function | Excel Worksheet Functions | |||
| can you nested sum and round function within if function? | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
