View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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