Vlookup and IsError functions in sports data

[Jwan622]

[TABLE="width: 569"]
<colgroup><col span="2"><col><col span="4"></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD][/TD]
[TD][/TD]
[TD]Day 1[/TD]
[TD]Day 2[/TD]
[TD][/TD]
[TD]Average data (if there does not exist data for both days, use 1)[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]Durant[/TD]
[TD]Kevin Durant[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]41.6[/TD]
[TD][/TD]
[TD]??[/TD]
[/TR]
[TR]
[TD]LeBron[/TD]
[TD]James[/TD]
[TD]LeBron James[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]56.6[/TD]
[TD][/TD]
[TD]??[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]Love[/TD]
[TD]Kevin Love[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]47.5[/TD]
[TD][/TD]
[TD]??[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD]Paul[/TD]
[TD]Chris Paul[/TD]
[TD="align: center"]42.3[/TD]
[TD="align: right"]#N/A[/TD]
[TD][/TD]
[TD]??[/TD]
[/TR]
[TR]
[TD]Carmelo[/TD]
[TD]Anthony[/TD]
[TD]Carmelo Anthony[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]38.3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]Wall[/TD]
[TD]John Wall[/TD]
[TD="align: right"]54.7[/TD]
[TD="align: right"]41.4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



So here's the problem. This is a section of my 6000 entry excel file. In the Day 1 column, I have the point total for some point weighing system. If there's an N/A it means they didn't play on day 1. In Day 2 column, there's the point total for some point weighing system (these are like fantasy points). In the average column, I want to compute the average IF both days there exists fantasy points. If there's only points for Day 1 or Day 2, then I want to use that day's point total and don't average it. How do I do this?

 

[ameya]

=IF(NOT(OR(ISERROR(A1),ISERROR(B1)),AVERAGE(A1,B1),IF(ISERROR(A1),B1,A1))

not tested, but I think that should work.

 

[ameya]

* messed up parathesis

=IF(NOT(OR(ISERROR(A1),ISERROR(B1))),AVERAGE(A1,B1),IF(ISERROR(A1),B1,A1))

 

[ameya]

Let me know if it works. Good luck.