Need help with simple formula....

[NHhunter]

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!

[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

"NHhunter" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[NHhunter]

That worked! Thanks Paul!

[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

"NHhunter" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>