|
|
#4
07-26-2011, 10:40 PM
|
|||
|
|||
i just realised on my sheet that with the above formulae its giving me error
S-1 2012 figures = 0 (D10) 2013 figures = 34,000 (F10) it should show 100% increase in expense but it's giving me "-". the forumale i am using =IF(ISERROR((F10-D10)/D10),"-",(F10-D10)/D10) i also tried this formula, but still "-" =IF(ISERROR((F10-D10)/D10)=TRUE,"-",(F10-D10)/D10) help please thanks 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Word Visual Basic error - run time error 504 | crazymorton | Word | 11 | 01-13-2012 04:32 AM |
| Ms Word Error | manesh | Word | 1 | 05-28-2010 07:26 AM |
| Circular error | markg2 | Excel | 2 | 05-17-2010 07:39 AM |
| Runtime error 5487 - Word cannot complete the save to to file permission error | franferns | Word | 0 | 11-25-2009 05:35 AM |
| Receive error cannot open this form because an error occurred in BCM 2007 | bornhusker | Outlook | 0 | 06-01-2009 10:28 AM |
Windows XP 
Office 2010 64bit
Threaded Mode