| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Errors
I dont want to display anything when cells referenced by formulas dont have
values and I've been using the IF mechanism to test for values using the IF(SUM)<0 OR IF(COUNT)=0 OR something like IF(P19<0,(P19/$P$19),""). It all works fine however when the refernced cells have formulas in them (which do the same test) I still get errors like #VALUE! and #DIV/0! how can I get rid of these. One case where I'm getting #VALUE! is a cell whose format is percentage could that be a problem as well? -- Wether you think you can or you think you cant , you are right ... anon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula errors | Excel Worksheet Functions | |||
| Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
| date formula errors | Excel Worksheet Functions | |||
| Formula errors | Excel Discussion (Misc queries) | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
Threaded Mode
