Hello gurus,

I would love it if the following conditional statement could return a truly
blank cell:

=IF(A5=2,A17,BLANK)

Unfortunately it returns an error when A5<2.

I am trying to average only numbers that meet certain conditions and thus
replacing BLANK by zero throws off my results.
What would I put in in place of BLANK to get an empty ignorable cell out?