Return blank cell from conditional

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

The empty string ""...

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

Rick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

End(xlDown) giving me blanks 1
Delete blank rows 7
If statement in macro to find blank cell/value in another cell 1
How to write a Clearcontents command in a macro 4
Substituting zero values in blank cells 5
Create if partial match then copy and paste data from one cell to another 1
Conditional Formatting Blank Cell 1
conditional formatting update issue 5

Back
Top