IF OR

G

Guest

I want to test the value of two columns, with a formula that says IF G1>0 OR
I1>0, 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(G1>0,IF(I1>0,"Y",""))

This looks so simple, but I've hit a brain block!

TIA,
CaroleO
 
G

Guest

=IF(OR(G1>0,I1>0),"Y","")

Or

=IF(OR(AND(ISNUMBER(G1),G1>0),AND(ISNUMBER(I1),I1>0)),"Y","")
 
G

Guest

Thanks to both of you! So simple - MSHelp really doesn't address IF OR, IF
AND. So thankful for this forum!

CaroleO
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set cell value to emptry if three other columns are empty too 1
Auto fill drop down stops at second cell 2
Please help with a formula 6
Formula IF OR 3
IF statement questions 2
Loop and autofill 1
When application.Calculation is manual do Worksheetfunction.sum willnot function for that part of co 3
find first data in a row 3

Top