Can't get ARRAYFORMULA to work

[ThinhDinh]

Hi Geir, here’s what you can build on.

Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts

Do you mind sharing a copy of the data to ariesarsenal@gmail.com so I can try directly on it? Thank you. Just that sheet will be enough. Edit: Found the problem. Don’t use AND in ARRAYFORMULA because it won’t work. Right formula for your case: ={"Aqius Value";ARRAYFORMULA(IF((H2:H="")*(U2:U="")=1,"",IF((H2:H<>"")*(U2:U<>"")=1,VALUE(U2:U),IF((H2:H<>"")*(U2:U="")=1,"No data",""))))} You can use the +0 method, or the VALUE one.