Forum Discussion
waqasmk1
Apr 13, 2022Copper Contributor
Excel formula
Hi Excel community. I am in need of some help. I have been working on this problem for a while and not able to work it out.
If you look at below image. I need help with Option B where I need profit to come to 0 with formula. If I simply put 5 under price column, profit will come to 0 but I am looking for some kind of formula where price automatically calculated and brings the value to 5
| Option | Price | Interest | Payout | Profit |
| A | 10 | 3 | 30 | 20 |
| B | 3 | 0.00 | -10.00 |
3 Replies
- SergeiBaklanDiamond Contributor
- waqasmk1Copper Contributorno luck with this one Sergei
- SergeiBaklanDiamond Contributor
May you share your current formula?