Multiple IF Statements

[wfgfreedom]

Is there a way to have a double condition If Statement?

Eg. If x = 0 and X > Y Then...

I am getting an error trying this. Please help!

Frank

 

[carlo]

hi frank

where do you need it? In a formula, in VBA?

In vba it would look like you wrote it:

if x = 0 and x>y then
'whatever you want to do, do it here
end if

in a formula it would be:
=if(and(x=0,x>y))

hth
Carlo

 

[wfgfreedom]

hi frank

where do you need it? In a formula, in VBA?

In vba it would look like you wrote it:

if x = 0 and x>y then
   'whatever you want to do, do it here
end if

in a formula it would be:
=if(and(x=0,x>y))

hth
Carlo






- Show quoted text -

I don't know what I did wrong, but it seems to work now.

Thanks for your help.

Frank