SOLVED

New Contributor

# #NUM! error

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

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

4 Replies

# Re: #NUM! error

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

# Re: #NUM! error

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

# Re: #NUM! error

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

Ok thanks.