Formula

  • Thread starter Thread starter Fran
  • Start date Start date
F

Fran

Can you help me with a formula for the following:


Regarding Stocks:

High Low Avg Shares Value



I have to get the average and value amount knowing the
high, low & shares.


Thank you.
 
One way:

Assuming High in column A, Low in column B, etc, and assuming the
value should be taken from the Average:

C2: =AVERAGE(A2:B2)
E2: =C2*D2
 
Back
Top