In need of a formula where one product, A-E, is chosen in a single cell. From there, I need two different results. The best way I can describe it is if, for example, "A" then result B149 and in a separate cell, if "A" then B90+B100+B110. I've tried different variations with no luck. One of the simplest formula's tried was =If(B2="A"),(B149)*(if(B2="B"),(E149)) the other was =if (B2="A"),(B90+B100+B110)*(if(B2="B"),(C90+C100+C110)) on out to "E".

My apologies, I don't get the opportunity to work on excel too often. I'm sure this is a simple formula, goes bad for me as soon as I get into the multifunction. I'm hung up and can't get past this. Any help would be greatly appreciated.

Thanks!
Mike