Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Or...Yet again!
it should work. just tested and it does work.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|