SOLVED

#NUM! error

Copper Contributor

Hi

I am getting a #NUM error when trying to calculate the Ut value as shown below.

The formula used is Ut= Up/e^n

Ut= -0.2070/(-101.22^4.79)

= #NUM error

 

RishS2001_0-1649406768864.png

What am I doing incorrectly and how can I correct it?

 

4 Replies

@RishS2001 I'm pretty sure that n must be a whole number.

I tried that, it didn't work.
best response confirmed by Grahmfs13 (Microsoft)
Solution

@RishS2001 Sure it will, though I can't judge that the answer is what you expect.

Riny_van_Eekelen_0-1649408278523.png

 

Ok thanks.
1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution

@RishS2001 Sure it will, though I can't judge that the answer is what you expect.

Riny_van_Eekelen_0-1649408278523.png

 

View solution in original post