Changing cell values to yield a specific value in another cell
I am using Windows 10 and MS Office 365. It's been a long time since I've used Excel, and forgot which function allows a specific cell value to change based on specific parameters in another cell. For example, assume I have a spreadsheet that calculates an investment return on a land purchase - and the return is 5%. I want to know how the land purchase price would have to change to make the return 10%. Can you help??
Thanks,
Phil
Thanks,
Phil
This is pretty easy, what you need is to put in the formula in Excel.
29152020.xlsx
29152020.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
Happy to help
If it's not too much, can you please upload a sample workbook and describe what you need done with some screenshots? It's a bit difficult to outline your current inputs and desired outputs just based on the description above....