i am building a spreadsheet with excel and need help with a formula. it has to do with avg pointspread. i cant just enter it normally because some of the results will come out in negative numbers. for example,if d2 =122 and e2=130 then the avg in f2 will be expressed negatively. otherwise i will have to have two diferent formulas. please keep your answers simple as i am new to excel.
2006-07-01 15:43:40 · 4 answers · asked by ron m 2 in Computers & Internet ➔ Programming & Design
=AVERAGE(D2:E2)
and my answer is 126 using the numbers you provided for D2 and E2
2006-07-01 15:48:12 · answer #1 · answered by wine_of_circe 2 · 0⤊ 0⤋
Not an expert either...but try pulling down format from the tool bar and selecting a text format instead of the typical numbers. This may help eliminate ur problem.
My other suggestion would be google the issue.....google is king.
2006-07-01 22:49:14 · answer #2 · answered by lee 2 · 0⤊ 0⤋
The formula used to average 2 number is (n1 + n2)/2 where n1 and n2 are positive numbers. This cannot lead to a negative result, so I don't see your problem. Perhaps you haven't explained your problem with enough detail..
Terrible T
2006-07-01 23:06:31 · answer #3 · answered by Terrible Terry 1 · 0⤊ 0⤋
Try the Microsoft Online Help page below, Using Solver to rate sports teams....
2006-07-01 23:06:42 · answer #4 · answered by Rev Debi Brady 5 · 0⤊ 0⤋