Camparing against multiple criteria

[cmerrick]

Please help with a formula I'm trying to work out.

I'm trying to return a 'Pass' or 'Fail result based on the following.

My criteria is below.

A = Loan + Interest
B = Loan to Value (%) inc Interest

C = Max Loan @ 75% (£750,000)
D = Max Loan @ 70% (£1,000,000)

E = Max LTV 75%
F = Max LTV 70%

I need to display a 'Pass# result IF both A & B do not exceed C/D/E/F

But I need the formula to move in Brackets. It first needs to check if A or B exceed C or E, if they do, it should then check if they exceed D or F.

If A or B still exceed then the 'Fail' message should be displayed.

Please ask if you need a further explanation

 

[AlanY]

Re: Camparing against multiple criteria. Help Please.

try this

=IF(OR(AND(A1>C1,A1>D1),AND(B1>E1,B1>F1)),"Fail","Pass")