#1
|
|||
|
|||
Trying to hide error message, but IFERROR edit says "too few arguments"
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word Template - Userform launch from QAT giving error "Wrong number of Arguments" | dan88 | Word | 6 | 05-17-2016 10:03 AM |
Error Message "Not Implemented" | JimP | Outlook | 0 | 10-12-2013 08:16 AM |
Word 2003 "The information you were working on might be lost" constant error message | 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 |
MYOB and "Item.Send error" Outlook message | peter_lambros | Outlook | 1 | 12-06-2008 08:24 AM |