Struggling with what id think would be a simple If Statement

[Gary Love]

Hi,

I am trying to create an if statement that says (and i know this is incorrect)
IF Z19 = 1 AND AA19 = 0 TRUE = CHECK SCM FALSE = IGNORE

SIMILARLY I NEED

IF Z19=1 AND AA19=0 AND AB19=0 TRUE = FLAG FALSE = OK

Been bashing my head for an hour on this PLEASE HELP!!!

Gary

 

[GS]

Hi,

I am trying to create an if statement that says (and i know this is
incorrect) IF Z19 = 1 AND AA19 = 0 TRUE = CHECK SCM FALSE = IGNORE

SIMILARLY I NEED

IF Z19=1 AND AA19=0 AND AB19=0 TRUE = FLAG FALSE = OK

Been bashing my head for an hour on this PLEASE HELP!!!

Gary

=if(and(z19=1,aa19=0,ab19=0),true,false)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[GS]

I'm assuming my one example for your 2nd example will help you figure
out the 1st example!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Gary Love]

I'm assuming my one example for your 2nd example will help you figure out the 1st example! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion

Works a treat, Thanks very much!!

Yeah just needed a push in the right direction. Thank you

 

[GS]

Works a treat, Thanks very much!!

Yeah just needed a push in the right direction. Thank you

Glad to help! Reading 'between the lines' suggested a 'push' was all
you needed! I appreciate the feedback...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion