Help need with if statement for acceptance criteria

[justin_n84]

Hi,

I need help with an if statements as I have tried a couple of things now and I just keep getting errors.

I have a table (see image) and its in regards to an acceptance criteria. I need the formula outcome to state accept or reject.

I have also uploaded a screenshot of the acceptance

Terms are:

If length greater than 0.75 of thickness it cannot be greater than 1 height to be acceptable If length greater than 3.5 * thickness it is a reject If depth is 0 height cannot be more than 2 otherwise it is a reject If total depth is equal to thickness height cannot be more than 2 - Otherwise reject Height at any point cannot be more than 3 - Otherwise it is a reject If it is not a reject - Accept Any help would be greatly appreciated

 

[earthworm]

you need to mention the answer you desire . please mention all scenario in example as its difficult to understand.

 

[justin_n84]

Accept or reject

 

[justin_n84]

I think I've worked it out myself


=IF(OR(AND(F2>=B2*0.75,H2>1),AND(F2>B2*3.5),AND(I2>=B2,H2>1),AND(H2>3)),"Reject","Accept")