Question about Computers & Internet
The IF() is the wrong one to use. Use "Iif()", as in:
=IiF(A3='Audit Exception Register'!B:B, COUNTIF('Audit Exception Register'!P:P,Y), 0)
Caveat about using Iif(), one that doesn't probably apply in this case, but keep it in mind: Don't use Iif when trying to return the values of "real" objects. Examples of "non-real" objects in the VB/A world are:
Integer, Double, etc... all the numeric "objects"
These are fine to use in IIf() statements. If however you will be returning some value that is part of an object, as in:
Iif(x=2, myObject.getSomeVal(), 0)
You run the very real risk that is myObject is null, your program will simply stop running. Iif() will NOT return a null error/exception; it will in fact just stop. This is a bug in the VB interpreter and/or in the Iif() function itself.
I am referring here to classic VBA (ie, pre-VB dot-Net). How .NET handles such cases, I don't know.
Posted on Mar 07, 2008
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Oct 21, 2009 | Microsoft Excel for PC
Jun 12, 2009 | Microsoft Excel for PC
Apr 10, 2009 | Microsoft Excel for PC
Nov 26, 2008 | Microsoft Office 2003 Basic Edition...
May 27, 2008 | Microsoft Excel for PC
Nov 06, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)
159 people viewed this question
Usually answered in minutes!