Calculated fields in Pivot Tables

Is it possible to use an "if" formula when creating a calculated field?
I have an existing field in my pivot table called commissions and I
want to create a new field that will give me a 1 if for each row if
commissions are over 4 and a 0 if they are under 4. Is this possible?
What is the formula?

It seems ok
Try something like : =IF(Commissions>=4,1,0)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"lj" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to use an "if" formula when creating a calculated field?
> I have an existing field in my pivot table called commissions and I
> want to create a new field that will give me a 1 if for each row if
> commissions are over 4 and a 0 if they are under 4. Is this possible?
> What is the formula?
>

> Try something like : =IF(Commissions>=4,1,0)

The above formula is inserted within the "Insert Calculated Field" dialog
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--