Excel #NUM Error

Copper Contributor

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.

1 Reply

Hello @PlanesAreReal 

SAMPLE.JPG