Solved

# Excel function query- MAX with nested IF and OR statement

Posted on 2014-07-12
321 Views
Im getting a wrong answer for a formula I have written using MAX function with nested IF and OR statements.
Best explained through the attached file.
Can someone correct formula.
Thanks
Excel-Formula-Issue.xlsx
0
Question by:gh_user

LVL 8

Accepted Solution

Try this

Array Formula
``````=MAX(MAX(IF((\$A\$3:\$A\$8)="U",\$B\$3:\$B\$8)),MAX(IF((\$A\$3:\$A\$8)="F",\$B\$3:\$B\$8)))
``````

Thanks
0

Author Comment

That works thanks.  Do you know why my formula didnt?
0

LVL 8

Expert Comment

You can by your self - Excel Tab - Formulas - Formula Auditing - Evaluate formula.

Thanks
0

## Write Comment

Please enter a first name

Please enter a last name

We will never share this with anyone.

## Featured Post

### Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

#### 761 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

#### Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!