graciegrey
New Member
- Joined
- Jul 7, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I need to reverse a formula for my list price to match our Gross Margin %. They all need to =65% GM.
Ex:
List Price: $267.87 (C4)
Landed: $44.21 (E4)
GM%: 83% (H4)
New List Price: ?
New GM%: 65%
Is there an excel formula that can make this easier for me to apply to all the other prices that need changed?
My boss just told me to play around with the list price until I can get to 65%. But I believe there's got to be an easier quicker way to get there with an excel formula. I'm Stumped.
Ex:
List Price: $267.87 (C4)
Landed: $44.21 (E4)
GM%: 83% (H4)
New List Price: ?
New GM%: 65%
Is there an excel formula that can make this easier for me to apply to all the other prices that need changed?
My boss just told me to play around with the list price until I can get to 65%. But I believe there's got to be an easier quicker way to get there with an excel formula. I'm Stumped.