How to correct a #NUM! error - Microsoft Support
https://support.microsoft.com/en-us/office/how-to-correct-a-num-error-f5193bfc-4400-43f4-88c4-8e1dcca0428b
WEBTo avoid the #NUM! error, enter values as unformatted numbers, like 1000, instead. Excel might also show the #NUM! error when: A formula uses a function that iterates, such as IRR or RATE, and it can’t find a result. To fix this, change the number of times Excel iterates formulas: Select File > Options.
DA: 21 PA: 30 MOZ Rank: 18