Forum Discussion

waqasmk1's avatar
waqasmk1
Copper Contributor
Apr 13, 2022

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

 

OptionPriceInterestPayoutProfit
A1033020
B 30.00-10.00

Resources