Prev: What keyboard keys for to increse font size?
Next: Don't Count Duplicates
From: Kay on 24 Apr 2010 10:43
Simple question...Can you use an If function in a PivotTables formulas
(Calculated Field)? If so can you provide an example for syntax purposes.
Thank you!
From: Dave Peterson on 24 Apr 2010 11:03
If you want to get to the format cells dialog quickly, you can use:
ctrl-1

But then you're still using the dialog...

Kay wrote:
>
> Simple question...Can you use an If function in a PivotTables formulas
> (Calculated Field)? If so can you provide an example for syntax purposes.
> Thank you!

--

Dave Peterson
From: Kay on 24 Apr 2010 11:54
Hi Dave,

I think you are responding to the wrong Kay...My question is about
PivotTables. Can you use an IF in a calculated field. (Formula)

"Dave Peterson" wrote:

> If you want to get to the format cells dialog quickly, you can use:
> ctrl-1
>
> But then you're still using the dialog...
>
> Kay wrote:
> >
> > Simple question...Can you use an If function in a PivotTables formulas
> > (Calculated Field)? If so can you provide an example for syntax purposes.
> > Thank you!
>
> --
>
> Dave Peterson
> .
>
From: Dave Peterson on 24 Apr 2010 13:41
Yes. You're right.

Sorry.

Kay wrote:
>
> Hi Dave,
>
> I think you are responding to the wrong Kay...My question is about
> PivotTables. Can you use an IF in a calculated field. (Formula)
>
> "Dave Peterson" wrote:
>
> > If you want to get to the format cells dialog quickly, you can use:
> > ctrl-1
> >
> > But then you're still using the dialog...
> >
> > Kay wrote:
> > >
> > > Simple question...Can you use an If function in a PivotTables formulas
> > > (Calculated Field)? If so can you provide an example for syntax purposes.
> > > Thank you!
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson
 | 
Pages: 1
Prev: What keyboard keys for to increse font size?
Next: Don't Count Duplicates