Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Use ISERROR Function in Excel Like an Expert

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 262

PostPosted: Sun Feb 05, 2017 1:39 pm    Post subject: Use ISERROR Function in Excel Like an Expert Reply with quote

The ISERROR Function returns TRUE if it finds cells containing error like #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!


Its syntax is very simple with only one argument

=ISERROR(value)

Most cases, the 'value' argument is a cell reference.



In the following example, I will calculate per day working hour in Column D. For me, it's more practical to use the ISERROR function inside an IF function, so that if there occurs an error in the calculation, I can see the cells for further corrections with a friendly notice rather than those nerve-taking typical error warnings like #DIV/0! or #NUM!, so to say.


So in cell D3 enter

=IF(ISERROR(B3/C3);"Need Attention!";B3/C3)


Copy the formula down the column you can see the cells that nee your attention!!







Let's try something different:


Let's say, your colleague sent you an Excel sheet full of calculations with plenty of errors, and you would like to mark those erro cells before you proceed to rework on the file.





Select the whole sheet (Ctrl + A)

Go to Conditional Formatting (under Home tab) > click on New Rule...





The New Formatting Rule window opens > select Use a formula to determine which cells to format.

Enter the following formula in the field under Edit the Rule Description:

=ISERROR(A1)

From the Format... button select any color to highlight the error cells > click OK.





The result is as follows:





Good work ahead Smile




Simple and easy: How to use 'If Function' in Excel







*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.


For comments of suggestions, please contact us: info@shamskm.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group