Formula

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.
 
J

J.E. McGimpsey

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
 
Top