Hello,
I have created an Excel simulator for two products (own and competitior's). I can now change the product's prices to see the share of preference for my product.
I would like to create on a separate sheet, a table which display the Share of Preference of my product for all the possible price combinations, e.g. between 50$ and 800$.
I don't know how to do it or where to retrieve the formula in the Excel simulator to do so.
Is there any way to do this?
Many thanks!