Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I SET UP A PRECEDENCE DIAGRAM?
I do not know how to do a precedence diagram. Please help
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I SET UP A PRECEDENCE DIAGRAM?
Hi,
I'm not sure what you mean by a precedence diagram, however, if what you want to see are the Precedence arrows (which can be printed): 1. Select a cell with a formula 2. Choose the command Tools, Formula Auditing, Trace Precedences This will cause a blue arrow to appear. It's easier to work with this feature if you float the Formula Auditing toolbar - Tools, Formula Auditing, Show Auditing Toolbar. You can click the Trace Precedence button more than once to show multiple levels. Unfortunately this command works on one cell at a time - this does not mean that you can only tract precedences for one cell, but that you need to select each cell one at a time, you can't apply it to a range with a single command. -- Cheers, Shane Devenshire "G Heard" wrote: I do not know how to do a precedence diagram. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Module Precedence? | Excel Discussion (Misc queries) | |||
MAJOR BUG: Excel operator precedence is wrong | Excel Worksheet Functions | |||
Diagram | Excel Discussion (Misc queries) | |||
Need explanation on operator precedence | Excel Discussion (Misc queries) | |||
With formulas does anyone know the order of precedence BOMDAS | Excel Worksheet Functions |