Returning a value from two fields

Yusuf

Active Member
Joined
Jun 1, 2004
Messages
337
Hi

Is it possible to create and IIF formula that returns a value only if both fields equal certain criteria?

Eg.
Field1 - Voluntary
Field2 - Complete

The return in the IIF formula should be the number "1"
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

giacomo

Well-known Member
Joined
Feb 20, 2002
Messages
1,796
iif([Field1] = "Voluntary" AND [Field2] = "Complete",1,0)
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,458
Office Version
  1. 365
Platform
  1. Windows
Sure, something like:

MyValue:IIF(([Field1]="Voluntary") And ([Field2]="Complete"),1,0)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,048
Messages
5,526,472
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top