| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simple interest formula in excel | Excel Discussion (Misc queries) | |||
| Simple formula help | Excel Worksheet Functions | |||
| help with simple formula | Excel Worksheet Functions | |||
| Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions | |||
| Please Reply! I Need A Simple Formula | Excel Worksheet Functions | |||
Hybrid Mode
