Thread: IF OR
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CaroleO CaroleO is offline
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