#VALUE from IF AND CONCATENATE formula in Excel

by |Published April 17, 2020

Anyone have thoughts on why this won’t work? I keep getting #VALUE.

=IF(E22:K22<>“”, CONCATENATE(E22, ” “, “of”, ” “, G22, ” “, “with”, ” “, K22, ” “, “from”, ” “, I22), “”)