ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculate the intersection of supply and demand curve (https://www.excelbanter.com/excel-worksheet-functions/24744-calculate-intersection-supply-demand-curve.html)

Angus

Calculate the intersection of supply and demand curve
 
How to calculate the intersection (price and quantity) of
supply and demand curves, which are drawn by equation (or
actual data of observation)?

Bernie Deitrick

Angus,

If you have two formulas, you set up the two formulas to refer to the same
input cell, and subtract them, and use Solver to set the result of the
subtraction to zero by manipulating the input cell.

If you have data, you need to fit a curve first.

HTH,
Bernie
MS Excel MVP


"Angus" wrote in message
...
How to calculate the intersection (price and quantity) of
supply and demand curves, which are drawn by equation (or
actual data of observation)?





All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com