Additonal Condition to IF function

[bigroo1958]

Hi All,

I have this Max/If function that works as wanted

Please Login or Register  to view this content.

I need to now add "Reasonably" as well as "Yes", how do I modify this formula?
So, I want both to be true, Yes and Reasonable

Thanks

[TMS]

Maybe try:

Please Login or Register  to view this content.

[bigroo1958]

Thanks TMS, that works great!!

[TMS]

You're welcome.

[bigroo1958]

mmmm, I thought this was working right, but I am not getting the correct last date back.
I am look for the last date that that Driver had an @ fault incident. I seem to be getting the correct date when only look for "Yes", but as soon as I add "Reasonably Preventable (RP)" to the formula I do not return the correct date.
Can someone please advise what is going on??

Thanks

[JohnTopley]

Try

=MAX(IF(('Raw Accidents'!V2:V20="YES")+('Raw Accidents'!V2:V20="Reasonably Preventable (RP)")*('Raw Accidents'!C2:C20),'Raw Accidents'!C2:C20))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

[bigroo1958]

Hi John,

I have tried your formula and my dummy data and appears to work as wanted.
Monday, when I return to work, I will test on the real data dashboard.

Thanks again!!