Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Looking for formula Looking for formula
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 11-27-2016, 12:38 PM
jeffreybrown jeffreybrown is offline Looking for formula Windows Vista Looking for formula Office 2007
Expert
  
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default
Just add another logical test to the TRUE side of the IF statement.

=MAX(IF(A2:A19=D2,IF(C2:C19=TRUE,B2:B19)))
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for formula Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Looking for formula Formula Help yljayhawk Excel 5 07-11-2016 06:14 AM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
Looking for formula Formula Help withersd46260 Excel 2 04-30-2014 08:33 AM
Looking for formula Help with formula please. AndrewSE Excel 3 04-05-2011 08:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:07 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft