Need help with simple formula....
 

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

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

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

Thanks!


--
NHhunter
------------------------------------------------------------------------
NHhunter's Profile: http://www.excelforum.com/member.php...o&userid=29196
View this thread: http://www.excelforum.com/showthread...hreadid=489304

Need help with simple formula....
 

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

"NHhunter" wrote in
message ...

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

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

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

Thanks!


--
NHhunter
------------------------------------------------------------------------
NHhunter's Profile:
http://www.excelforum.com/member.php...o&userid=29196
View this thread: http://www.excelforum.com/showthread...hreadid=489304

Need help with simple formula....
 

That worked! Thanks Paul!


--
NHhunter
------------------------------------------------------------------------
NHhunter's Profile: http://www.excelforum.com/member.php...o&userid=29196
View this thread: http://www.excelforum.com/showthread...hreadid=489304

Need help with simple formula....
 

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

"NHhunter" wrote in
message ...

That worked! Thanks Paul!


--
NHhunter
------------------------------------------------------------------------
NHhunter's Profile:
http://www.excelforum.com/member.php...o&userid=29196
View this thread: http://www.excelforum.com/showthread...hreadid=489304