Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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