Forum Discussion

PlanesAreReal's avatar
PlanesAreReal
Copper Contributor
Jan 15, 2023

Excel #NUM Error

Excel is not calculating the numbers higher than the denominator in my formula. For example, Excel is supposed to divide my H2 value with a specific number in the denominator. Let's say my H2 value is 2.887112093 and that number is divided by 2.8584 (denominator). It says #NUM because the H2 value is bigger than that of the denominator. But if the H2 value is lower than the denominator, it would calculate that and give an answer. I need help with this error.

Resources