# Okay One More: IIF(And(IsNull

#### bthomas

##### Board Regular
How do you use IIF(And(IsNull together?

Here is the formula I am trying to create:

Zone!: IIF(And(IsNull([Zone]),IsNull([Opportunity]),"Zone!",""))))

What am I doing wrong? I can't seem to figure it out.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### Marbles

##### Well-known Member
The And should go there.

Zone!: IIF(IsNull([Zone]) And IsNull([Opportunity]),"Zone!","")

#### Norie

##### Well-known Member
Why not take a look at the Nz function?

#### bthomas

##### Board Regular
Thanks, Marbles!

I am not familiar with the Nz function. What is its purpose?

#### Joe4

The NZ function will convert a Null value into a value of your choosing.

If is quite useful when you are doing Outer Joins, and the field you are pulling back might not exist because there is no match. So, if you have a formula like this:

NZ([Field1],"No match")

it will return the value of Field1, if it exists. If it doesn't, it will return "No Match".

#### bthomas

##### Board Regular
Ohhh, Very cool! Thank you!

Replies
7
Views
942
Replies
2
Views
166
Replies
6
Views
200
Replies
5
Views
402
Replies
5
Views
321

1,191,516
Messages
5,987,026
Members
440,074
Latest member
Emmanuelian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back