Hello. I have a sheet that has multiple cells containing various amounts and use a simple formula to get a value. I can enter a value in A1 and it will subtract A2:A5 from A1 and give me the result in B1. What I need though is a formula that will tell me what value to enter in A1 to always get a result of 5 in B1. Is this possible? Thanks in advance for any help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel: Formula to find a specfic value
- Thread starter brobert95
- Start date
