# Camparing against multiple criteria

#### cmerrick

##### Board Regular

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.

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### AlanY

##### Well-known Member
Re: Camparing against multiple criteria. Help Please.

try this

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

Replies
2
Views
23
Replies
5
Views
60
Replies
0
Views
81
Replies
0
Views
65
Replies
3
Views
65