| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question on Formula Audit function
Hi,
I am a worksheet with some rather "involved" formulas. In trying to debug them, I have been using the Formula Audit. But now I find that sometimes this works and sometimes it shows me the value #NAME? The formula has no error, but the Formula Audit box only shows the Evaluate and Close radio buttoms. Step In/Step Out are grayed out. The formula appears below. Any ideas on what is causing this? =IF(HLOOKUP(EOMONTH(E$71,0),$E$11:$V$61,$A72,FALSE )=0,0,HLOOKUP(EOMONTH(E$71,0),$E$11:$V$61,$A72,FAL SE)*E$69/HLOOKUP(EOMONTH(E$71,0),$E$2:$V$8,7,FALSE)) -- Chuck |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Audit Problem | Excel Discussion (Misc queries) | |||
| Formula/Function Question | Excel Discussion (Misc queries) | |||
| Formula Audit toolbar | Excel Discussion (Misc queries) | |||
| Add "FIND LINKS" to EXCEL Audit function | Excel Worksheet Functions | |||
| Formula Audit Toolbar | Excel Discussion (Misc queries) | |||
Threaded Mode
