[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 350
  • Last Modified:

Excel function query- MAX with nested IF and OR statement

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
gh_user
Asked:
gh_user
  • 2
1 Solution
 
Naresh PatelTraderCommented:
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)))

Open in new window


Thanks
0
 
gh_userAuthor Commented:
That works thanks.  Do you know why my formula didnt?
0
 
Naresh PatelTraderCommented:
You can by your self - Excel Tab - Formulas - Formula Auditing - Evaluate formula.Evalute Formula

Thanks
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now