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
|