#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 281
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"