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

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 xy then
'whatever you want to do, do it here
end if

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

hth
Carlo


On Jan 22, 10:03*am, wrote:
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

On Jan 21, 8:23*pm, carlo wrote:
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 xy then
* *'whatever you want to do, do it here
end if

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

hth
Carlo

On Jan 22, 10:03*am, wrote:



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- Hide quoted text -

- Show quoted text -


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

Thanks for your help.

Frank