If I want to write in excel: Check all the cells in Column L if ="Toronto or "Vancouver" then check the corresponding cell in column B and if its less than 1 million and great or equal to 600k "yes" false "No"
=MAX(IF(OR(('large loans'!$L$6:$L$17="Toronto"),('large loans'!L6:L17="Vancouver")),'large loans'!B6:B17,))
is there a difference
=MAX(IF(('large loans'!L7:L18="Toronto")+('large loans'!L7:L18="Vancouver"))'large loans'!B7:B17,))
Why am I getting different outputs? and they are not the right outputs?![]()
Bookmarks