Sorry the title wasn't very descriptive, wasn't sure how to word this.
I have a spreadsheet with three columns: 1st Observation, 2nd Observation, Average.
In the observation columns, there will either be a number 1-5, or the letter 'N'.
For the average column:
If both columns contain "N", then the average column should be "N" - simple enough.
If neither column contains "N", then the average of the two numbers/observations should be calculated - also simple.
If only one column contains the letter "N', then the number from the column which isn't "N" should be returned.
So for example:
1st: 5, 2nd: 6, Average: 5.5
1st: N, 2nd: N, Average: N
1st: N, 2nd: 4, Average: 4
1st: 3, 2nd: N, Average, 3
How would I go about doing this?
Bookmarks