Return blank cell from conditional
 

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?

Return blank cell from conditional
 

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?

The empty string ""...

=IF(A5=2,A17,"")

Rick