IF Function Multiple logical tests - Syntax

I want to impose two conditions. Specifically, If G8=100 and H8=, value if true,value if false.
I am failing to find the proper syntax.
Any help would be appreciated.
Thank you. Good day.

Hi

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.


--
(When sending e-mail, use address )
Arvi Laanemets


"Jim333 " wrote in message
...
HI everybody,

I have a quesiton that puzzled me so much

I tried to use IF function with more than eight conditions, but that
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=437138
---
Message posted from http://www.ExcelForum.com/

Hi
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


HI everybody,

I have a quesiton that puzzled me so much

I tried to use IF function with more than eight conditions, but that
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=437138 ---
Message posted from http://www.ExcelForum.com/