In the excel document we have questions with answers ranging from 1 - 5.

What we need to do is calculate the value 1,2,3,4 or 5 from the given row and then take that value subtract 1 and then multiply the answer by 0.025.

After this we need to calculate the same value from the given row above and then take 5 minus the value from that range (1,2,3,4 or 5) then multiply the answer by 0.025 to get an average from all the questions.

Please explain how we could do this in Excel?

Thank You,
Ned