Need help with simple formula....

N

NHhunter

I'm in the process of using Excel in a ballistics project. I have jus
about all functions working exept one. I need to add the sum of tw
cells and dived by 2. Everything I have tried to use has come u
wrong.

Example A1=muzzle velocity, A2=velocity@50 yards, A3 is supposed t
equal A1+A2/2 (velocity at 25 yards). It just doesn't seem to work an
I'm sure it's my ignorance. Any suggestions?

Don't laugh, I just started using Excel yesterday.;)

Thanks
 
P

Paul B

NHhunter, try this,

=(A1+B1)/2

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
P

Paul B

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

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

HELP WITH GRAPHING PLEASE!!! 0
Menu Macro Not Executing - Need Help 1
Need help with IF statement (function) 1
Search cell value in same column 3
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Need Help with a VBA subroutine 0
Complex formula help , please. 13
Sort by Every Other Row? 1

Top