Formula to calculate only if a cell has value, else to be blank

Ask for Help
6

Try this formula instead
=arrayformula(IF(LEN(G2:G)=0,"",if(G2:G=H2:H,TRUE,FALSE)))

1 Like