I am basically trying to do a simple formula to determine share of business.
I have several drop down boxes, set to text format, with assorted selections. If the product selected is one of two of our brands, I want it to affect the formula. IF it is not, then I do not want it to count.
For VALUE If Value= A or B, then VALUE =1, If No A or B, ...