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