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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP isn't working properly in Excel on Mac 1
Average problem 1
Compare Cells of Text and Return Highest Value based on a Customiz 1
Conditional formatting formula 11
Help creating a formula 8
Can Excel do this? and if so which formula should I use 4
The Last of Us - Part I (PC) 6
Average of a list with high and low ignored 3

Back
Top