Microsoft Office Forums - View Single Post - [Solved] Looking for formula

Thread: [Solved] Looking for formula

View Single Post

Old

11-27-2016, 12:38 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown 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