if statement

[rbhedal]

I am trying to write a function that looks at a two cells and then gives the appropriate response. what I want it to look at is:

Grade System Condition Draft Pretension Payout Minimum FOS
ORQ chain intact survival 1.67

in the column under condition, I want it to look and if it says "intact" & if under "Minimum FOS" is less than 1.67 I want it to return a value of "FAIL" & if it is "damaged" & less than 1.25 I also want a response of "FAIL" any other case would be considered a "PASS." This is an easy function to write & it works for part of it.

If the value is intact & less than 1.67 I get "FAIL" for any other case I get "FALSE." I cannot find my error. Can anyone please help me. I have enclosed my function for review.

IF(G5=0," ",IF(C5="intact",IF(G5<1.67,"fail",IF(C5="damaged",IF(G5<1.25,"fail","pass")))))


Thanks.

[jasoncw]

Try this formula.

Please Login or Register  to view this content.

[rbhedal]

That didnt work. It only worked for values greater than 1.67. What i need is for excel to look at it & see that if it says "intact", it has to meet a certain criteria & if it sees that it says "damaged," it has to meet a different criteria. And, if it doesn't meet the criteria, then it passes.

Thanks in advance.

[jasoncw]

Maybe I am confused. The above formula looks for the following.

First, it looks at cell G5. If it is > or = 1.67, then it will return "pass".

Next, if it is < 1.67, if cell C5 is either "intact" or "damaged", then it will return "fail". Any other combination will return "pass".

Are you asking for something different?

[rbhedal]

What I need it to look for is cell C5. If cell C5 is "intact" then it moves to cell G5. If cell G5 is less than 1.67, it returns "FAIL." If cell C5 is "damaged," then cell G5 will fail if it is less than 1.25.

Is that clear?

[rbhedal]

NEVERMIND, I got it figured out. Thanks.

[jasoncw]

Sorry for the misunderstanding. Try this:

Please Login or Register  to view this content.