Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
View Values Formula is using?
Hi
I have a formula: =SUM(IF('Jan 08'!$B:$B="Day",IF('Jan 08'!$E:$E=A3,'Jan 08'!F:F,0),0)) and this is returning me a value of 0 when it should be 2. Is there a way I can see step by step what Excel is calculating for each part of my statement to see what it is doing? Cheers Rich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set the Options to View Zero Values to be off always | Excel Discussion (Misc queries) | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
View of x-axis values | Charts and Charting in Excel | |||
View formula results instead of formula in 2003 version? | Excel Discussion (Misc queries) | |||
How do I view formulas by values not by which cells they use to c. | Excel Discussion (Misc queries) |