two way table/scenario analysis for product profit

[stephme55]

Hello. I have a tab with product cost and revenue in it. Can someone show me some ways to create scenario analysis or two way tables that show profit, based on varying product cost, price, and units? Thanks!!!!!!!!!!! Spreadsheet attached.

[Ochimus]

stephme55,

Attached is an approach that shows you the impact of changing either or both of two factors, which you can adapt.

Ochimus

[stephme55]

Thank ye thank ye.

[Ochimus]

If you are happy with the solution, can you mark the thread as "solved", please? ('thread tools' drop box at top of screen, select "solved")

Ochimus