Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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(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(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
|
|||
|
|||
![]()
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 | |
|
|