I am trying to convert a Google Sheets document into an excel document and my formulas are not transferring over correctly. This is the formula from the Google Sheets document. ={"Positivity Number";ARRAYFORMULA(if(D3:D="Low", "0", (if(D3:D="Medium", "1", (if(D3:D="High", "2",))))))} I have this formula pasted in a title box that is labeled "Positivity Number". Can you please help me convert this formula into one that will work with Excel?
Solved by E. A. in 27 mins