G

#### Guest

I am failing to find the proper syntax.

Any help would be appreciated.

Thank you. Good day.

G

I am failing to find the proper syntax.

Any help would be appreciated.

Thank you. Good day.

Ad

A

Hi

=IF(AND(G8>=100,H8>=33),ValueForTrue,ValueForFalse)

Arvi Laanemets

=IF(AND(G8>=100,H8>=33),ValueForTrue,ValueForFalse)

Arvi Laanemets

J

H8>= ???If G8>=100 and H8>= ????

Is this what you were looking for??

=IF(AND(G8>=100,H8>=100),"both greater","false")

John

N

=IF(AND(G8>=100,H8>=200),"YES!!","alas, no")

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

G

Thank you Arvi, John, Niek

I'm sure one of those will work

Good day again

Mark

I'm sure one of those will work

Good day again

Mark

A

I hope so!

They are ja all three the same )

Arvi Laanemets

They are ja all three the same )

Arvi Laanemets

Ad

J

I have a quesiton that puzzled me so much

I tried to use IF function with more than eight conditions, but tha

formula did not work,

Is there any other function in excel can do me that job.

I attached a work book in order to explain my question better

Thank you

Attachment filename: if multiple conditions.xls

Download attachment: http://www.excelforum.com/attachment.php?postid=43713

A

There are up to 7 nested IF's allowed.

When you want our advice, explain here in message body (no attachments!),

what you have and what you want to do - so you get some answer more likely.

At least I myself have a couple of times tried to get some links to this

excelforum to work, and it's enough for me.

F

You're restricted by a maximum of 7 nested staements. I would use

VLOOKUP in your case (though I haven't opened your worksheet). Try the

following:

1. Create a list with your conditions and the results per

condition(lets say on a separate sheet named 'conditions'):

A B

cond_1 1

cond_2 2

...

cond_20 20

If your value to test against the conditions is stored in A1 try the

following:

=VLOOKUP(A1,'conditions'!A1:B20,2,0)

will return the value from column B, where A1 equals the value in

column A of your condition sheet

Frank

J

First of all, I really appreciate your fast and valuable help to al

member in this group

I applied the formula you provided and found it excellent and workin

very well. On another hand, after posting my question I tried to find

formula that can do me what I want and after many tries I did find

good formula by using both VLOOKUP & HLOOKUP.

I attached the book and you can see what I did.

Thank you again fran

Attachment filename: if multiple conditions.xls

Download attachment: http://www.excelforum.com/attachment.php?postid=43849

Ad

i want to add one more logical test that is =IF(COUNTIF(H13:NN13,1)=0,"",COUNTIF(H13:NN13,1))

how can i make it in only one and the same cell

please help me..thank you

Ad

**Want to reply to this thread or ask your own question?**

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.