Hi Everyone,
I'm trying to multiply values in column B if the values in column A meet a certain criteria. Example:
Column A: discount type
Column B: discount value
Column A Column B
Rebate 2%
Rebate 1.5%
Discount 3%
Discount 2%
Rebate 5%
Ideally, it should multiply 2%*1.5%*5%.
What's the easiest way to do this? I've only been seeing sumproducts but it doesn't really solve for my purpose.
Thank you very much!
Bookmarks