Converting Excel Formula to Open Office
Posted: Mon Dec 17, 2007 7:59 pm
I have a questionnaire that is written in excel and I need to convert a formula to open office. The formula is =COUNTIF(D1:D45,"Yes")/MAX(1,SUM(COUNTIF(D1:D45,{"Yes","No"})))
I get a #Name? error on open office when i copied and pasted the formula.
I have about 45 questions that can be answered yes, no or n/a. I need to know the percentage.
thanks
I get a #Name? error on open office when i copied and pasted the formula.
I have about 45 questions that can be answered yes, no or n/a. I need to know the percentage.
thanks