![]() |
#1
|
|||
|
|||
![]()
I have the following formula
=(G4/C4)-1 I don't want the cell to display "#DIV/0!" so I am trying to add the IFERROR function =IFFERROR(G4/C4)-1 and then add either ,_ or ,0 at the end. But it keeps saying "You've entered too few arguments for this function". Help?! ![]() |
#2
|
|||
|
|||
![]()
Try:
=IFERROR(G4/C4-1,0) Last edited by joeu2004; 07-16-2017 at 04:13 PM. Reason: Change null string to 0, per your instructions, which I overlooked |
#3
|
|||
|
|||
![]()
Perfect - thank you!
|
![]() |
Tags |
arguments, error, iferror |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
dan88 | Word | 6 | 05-17-2016 10:03 AM |
Error Message "Not Implemented" | JimP | Outlook | 0 | 10-12-2013 08:16 AM |
![]() |
rocketbeta | Word | 1 | 08-21-2012 02:54 PM |
How to edit the "Format" and the "show level" of an EXISTING table of content? | Jamal NUMAN | Word | 2 | 08-14-2011 10:46 AM |
![]() |
peter_lambros | Outlook | 1 | 12-06-2008 08:24 AM |