Solved

isnull sql server function in excel vba

Posted on 2013-12-20
1
1,168 Views
Last Modified: 2013-12-24
Is there a function that has similar functionality to the isnull sql server function in excel vba

need to replace null values with zero-
0
Comment
Question by:johnnyg123
1 Comment
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 500 total points
ID: 39732189
There isn't really a direct replacement but you can still use Excels version in combination with iif. Something like this:

iif(isnull(myvalue), 0, myvalue)
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now