if / then formula statement in a pivot

squeakums

Well-known Member
Joined
May 15, 2007
Messages
697
I need your help writing an if/then statement in a pivot table - I need to write if c5 is = 1 and d5 is equal to 0, then "closed" otherwise "still open"
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Chrisdontm

Well-known Member
Joined
May 4, 2015
Messages
810
In a Pivot Table the formula will convert to the column heading names.

If Column "C" has the heading: Column1
And Column "D" has the heading: Column2

If the place that you put the formula is up against the table, it will become part of the table.
And the formula will look like this:

=IF(AND([@Column1]=1,[@Column2]=0),"closed","still open")

If the formula is not apart of the table then it has to reference the table;
Lets say the Table is named: Table4
Then it will look like this;

=IF(AND(Table4[@Column1]=1,Table4[@Column2]=0),"closed","still open")
 

Watch MrExcel Video

Forum statistics

Threads
1,108,708
Messages
5,524,428
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top