Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

prev 1
• # How to solve #NUM! error in excel?

• 1
• 0
• 0
• 0
• 0
• 0
• 0
• 0
• 2.45k
Comment on it

Hello friends,

Many times while doing a calculation in excel we got stuck with errors such as, #N/A, #REF!, #NAME?, #DIV/0!, #NULL!, #VALUE! or #NUM!.

So here in this blog I am picking up #NUM! error and providing you the solution for this, please check the below steps.

1. The excel formula uses function to perform calculation ie. RATE.
2. You have to change the number of times excel performs or iterates formulas.
3. Go to Formula tab, under calculation option check Enable iterative calculation box.
4. After this in Maximum iteration box type how many times you want to excel to recalculate. Remember that if the number of iterations is higher it will take more time to calculate a worksheet.
5. Now look at maximum Change box, you have to type the amount of changes you want to accept between calc results. Also remember here if the number is smaller it will provide you more accurate result along with more time to calculate worksheet.
6. If A formula provides too large or too small number in excel, you have to change the formula so that it should result between 110307 and 110307.
7. Also turn on the error check on your excel and click (on error icon) next to cell which show the error. Click show calculation steps if available, and pluck the solution for your data.

## 0 Comment(s)

OR
OR
Register

OR
Fill out the form below and instructions to reset your password will be emailed to you:

• Hire
• Post Projects

### Post Projects

• All at 0 Cost ....
• Post Tech Job
• Select Best Bidder
• Track the Project
• Approve Work and Pay safely
• Browse Nerds
• Work
• Find Projects Find Projects
• UI Design and UX
• Software Engineering
View more...
View less...
• Marketing
• General
View more...
View less...
• Manage
• Company Company

### Manage Company

• All at 0 Cost ....
• Manage Company and Employee Profiles
• Company wide Employee Productivity Reports
• Knowledge Sharing and Collaboration Tools
• Get Sales Lead and Bid for Tech Projects
• Send Invoices and Receive Payment Safely
• Learn
• Nerd Digest Nerd Digest
• UI Design and UX
• Software Engineering
View more...
View less...
• Marketing
• General
View more...
View less...
• Tech Q & A Tech Q & A
• UI Design and UX
• Software Engineering
View more...
View less...
• Marketing
• General
View more...
View less...