Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Trying to hide error message, but IFERROR edit says "too few arguments"
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 07-16-2017, 03:15 PM
Lauren4242 Lauren4242 is offline Trying to hide error message, but IFERROR edit says "too few arguments" Windows XP Trying to hide error message, but IFERROR edit says "too few arguments" Office 2010 32bit
Novice
Trying to hide error message, but IFERROR edit says "too few arguments" 		 
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 Trying to hide error message, but IFERROR edit says "too few arguments" Windows 7 32bit Trying to hide error message, but IFERROR edit says "too few arguments" Office 2007
Advanced Beginner
  
Join Date: Aug 2016
Posts: 32
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 Trying to hide error message, but IFERROR edit says "too few arguments" Windows XP Trying to hide error message, but IFERROR edit says "too few arguments" Office 2010 32bit
Novice
Trying to hide error message, but IFERROR edit says "too few arguments" 		 
Join Date: Jul 2017
Posts: 2
Lauren4242 is on a distinguished road
Default
Perfect - thank you!
Reply With Quote
Reply

Tags
arguments, error, iferror

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to hide error message, but IFERROR edit says "too few arguments" 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
Trying to hide error message, but IFERROR edit says "too few arguments" 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
Trying to hide error message, but IFERROR edit says "too few arguments" MYOB and "Item.Send error" Outlook message peter_lambros Outlook 1 12-06-2008 08:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:32 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft