Or...Yet again!
 

Howdie,

Or question

Two columns g and H
in G is a formulae that will result in "Match" or N/A
In H is a formulae that will result in True or false

In column I, I'd like to be able to know if there is a "match" in column
G OR if there is a TRUE in column I. IF this condition is met put an
"okay", or else put "xx"

Why doesnt my formulae work....


IF(OR(G9="Match",H9=TRUE),"okay","xx")

Thanks guys....

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Or...Yet again!
 

Hi Darin

is it missing an = at the beginning
other than that it seems to work for me

Cheers
JulieD


"Darin Kramer" wrote in message
...


Howdie,

Or question

Two columns g and H
in G is a formulae that will result in "Match" or N/A
In H is a formulae that will result in True or false

In column I, I'd like to be able to know if there is a "match" in column
G OR if there is a TRUE in column I. IF this condition is met put an
"okay", or else put "xx"

Why doesnt my formulae work....


IF(OR(G9="Match",H9=TRUE),"okay","xx")

Thanks guys....

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Or...Yet again!
 

it should work. just tested and it does work.