Konecranes
New Member
- Joined
- Apr 14, 2015
- Messages
- 6
I'm trying to force a value to increase in one cell if another cell drops below a specific value.
Example: If D18 drops below of 10% of D6 then D6 must be a minimum of 90% of D18.
D18 = net profit (must stay at 10%)
D12 = gross profit
D10 = fixed costs
D6 = total sales (must stay at 90% or better of profit)
Sales - service = gross profit, gross profit - fixed costs = net profit
Example: If D18 drops below of 10% of D6 then D6 must be a minimum of 90% of D18.
D18 = net profit (must stay at 10%)
D12 = gross profit
D10 = fixed costs
D6 = total sales (must stay at 90% or better of profit)
Sales - service = gross profit, gross profit - fixed costs = net profit
Last edited: