Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

isblank function

If a column has blank, Id like to place 0 there otherwise use the number in the cell.
whats the isblank formula?
0
zachvaldez
Asked:
zachvaldez
2 Solutions
 
Jeff DarlingDeveloper AnalystCommented:
=IF(ISBLANK(A1),0,A1)

Open in new window

0
 
Saqib Husain, SyedEngineerCommented:
If the cell is empty and does not have a null string then you can simply use

=A1


If there are null strings then use

=if(A1="",0,A1)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now