• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Reasoning with sumproduct

rrocker1405

rrocker1405

Member
Hi,

I'm trying to get results for a survey and the question is like this.

the survery % completed by 62 participants is 48%. 10 participants out of 62 completed 63%. my question is how much the remaining 52 participants complete?

can we solve it using a formula in excel? its a simple logic but im not sure how to do it.

Thanks in advance.
Kind regards,
A!
 
Hi Anand ,

I don't know how or why SUMPRODUCT will be used , but see the file for simple arithmetic.

Narayan
 

Attachments

  • Book1.xlsx
    7.9 KB · Views: 15
Narayan you rock as always. thank you for solving this riddle. I was not aware that we can use round function to solve this :)
made my day...thanks once again.
 
You must log in or register to reply here.
Back
Top