| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR
I want to test the value of two columns, with a formula that says IF G10 OR
I10, put "Y" in T1. I have tried different variations of IF, OR, but nothing works the way I want it to - T fills up with FALSE, or blanks. =IF(G10,IF(I10,"Y","")) This looks so simple, but I've hit a brain block! TIA, CaroleO |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF OR
Hi,
in the cell T1 enther formula below: =IF(OR(G10,I10),"Y","") Thanks, -- Farhad Hodjat "CaroleO" wrote: I want to test the value of two columns, with a formula that says IF G10 OR I10, put "Y" in T1. I have tried different variations of IF, OR, but nothing works the way I want it to - T fills up with FALSE, or blanks. =IF(G10,IF(I10,"Y","")) This looks so simple, but I've hit a brain block! TIA, CaroleO |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF OR
=IF(OR(G10,I10),"Y",0)
"CaroleO" wrote: I want to test the value of two columns, with a formula that says IF G10 OR I10, put "Y" in T1. I have tried different variations of IF, OR, but nothing works the way I want it to - T fills up with FALSE, or blanks. =IF(G10,IF(I10,"Y","")) This looks so simple, but I've hit a brain block! TIA, CaroleO |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF OR
=IF(OR(G10,I10),"Y","")
Or =IF(OR(AND(ISNUMBER(G1),G10),AND(ISNUMBER(I1),I1 0)),"Y","") "Toppers" wrote: =IF(OR(G10,I10),"Y",0) "CaroleO" wrote: I want to test the value of two columns, with a formula that says IF G10 OR I10, put "Y" in T1. I have tried different variations of IF, OR, but nothing works the way I want it to - T fills up with FALSE, or blanks. =IF(G10,IF(I10,"Y","")) This looks so simple, but I've hit a brain block! TIA, CaroleO |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF OR
Thanks to both of you! So simple - MSHelp really doesn't address IF OR, IF
AND. So thankful for this forum! CaroleO "Toppers" wrote: =IF(OR(G10,I10),"Y",0) "CaroleO" wrote: I want to test the value of two columns, with a formula that says IF G10 OR I10, put "Y" in T1. I have tried different variations of IF, OR, but nothing works the way I want it to - T fills up with FALSE, or blanks. =IF(G10,IF(I10,"Y","")) This looks so simple, but I've hit a brain block! TIA, CaroleO |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
