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

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

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

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

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