Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-16-2017, 03:15 PM
Lauren4242 Lauren4242 is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Jul 2017
Posts: 2
Lauren4242 is on a distinguished road
Default 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?!
Reply With Quote
  #2  
Old 07-16-2017, 04:12 PM
joeu2004 joeu2004 is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Aug 2016
Posts: 15
joeu2004 is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 07-16-2017, 04:24 PM
Lauren4242 Lauren4242 is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Jul 2017
Posts: 2
Lauren4242 is on a distinguished road
Default

Perfect - thank you!
Reply With Quote
Reply

Tags
arguments, error, iferror

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 08:41 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft