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
Hello ned123,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
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
Please could you answer this quick question? much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks