Camparing against multiple criteria

cmerrick

Board Regular
Joined
Jun 8, 2017
Messages
75
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
 

Some videos you may like

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
Joined
Oct 30, 2014
Messages
4,169
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Re: Camparing against multiple criteria. Help Please.

try this

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

Watch MrExcel Video

Forum statistics

Threads
1,108,910
Messages
5,525,587
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top