I have a work sheet in which I need to find the lowest rate among multiple criteria.
Cell B1 is designated to provide a response of 1-22.
I'm looking to see how I can pull the lowest silver rate among Aetna, IBC and UHC if cell B1 is either 7 or 15, if not 7 or 15 pull in the lowest rate amount all carriers.
if cell B1 is 7 or 15 then give me the lowest rate of silver prices for Aetna, IBC and UHC.
Bookmarks