I want to implement the following formula using openxlsx: =IF(COUNTIF(E3:G3,”none“)=3,”N/A”,AVERAGE(IF(ISNUMBER(–E3:G3),–E3:G3,””))) to each row
This formula works perfectly in excel given the dataframe, however when I use openxlsx, it gives me the following:
=IF(COUNTIF(E3:G3, “none“) = 3, “N/A”, AVERAGE(IF(ISNUMBER(–@E3:G3), –@E3:G3, “”)))
and doesn’t give me the correct answer, how do I fix this and get rid of the @ symbol.