SOLVED

#NUM! error

%3CLINGO-SUB%20id%3D%22lingo-sub-3279833%22%20slang%3D%22en-US%22%3E%23NUM!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3279833%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20am%20getting%20a%20%23NUM%20error%20when%20trying%20to%20calculate%20the%20Ut%20value%20as%20shown%20below.%3C%2FP%3E%3CP%3EThe%20formula%20used%20is%20Ut%3D%20Up%2Fe%5En%3C%2FP%3E%3CP%3EUt%3D%20-0.2070%2F(-101.22%5E4.79)%3C%2FP%3E%3CP%3E%3D%20%23NUM%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22RishS2001_0-1649406768864.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F362342i4BA19493DDAC55B6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22RishS2001_0-1649406768864.png%22%20alt%3D%22RishS2001_0-1649406768864.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWhat%20am%20I%20doing%20incorrectly%20and%20how%20can%20I%20correct%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3279833%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3279854%22%20slang%3D%22en-US%22%3ERe%3A%20%23NUM!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3279854%22%20slang%3D%22en-US%22%3EOk%20thanks.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3279848%22%20slang%3D%22en-US%22%3ERe%3A%20%23NUM!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3279848%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1357431%22%20target%3D%22_blank%22%3E%40RishS2001%3C%2FA%3E%26nbsp%3BSure%20it%20will%2C%20though%20I%20can't%20judge%20that%20the%20answer%20is%20what%20you%20expect.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Riny_van_Eekelen_0-1649408278523.png%22%20style%3D%22width%3A%20241px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F362344iA28EB2F2323A60F2%2Fimage-dimensions%2F241x190%3Fv%3Dv2%22%20width%3D%22241%22%20height%3D%22190%22%20role%3D%22button%22%20title%3D%22Riny_van_Eekelen_0-1649408278523.png%22%20alt%3D%22Riny_van_Eekelen_0-1649408278523.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3279843%22%20slang%3D%22en-US%22%3ERe%3A%20%23NUM!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3279843%22%20slang%3D%22en-US%22%3EI%20tried%20that%2C%20it%20didn't%20work.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3279841%22%20slang%3D%22en-US%22%3ERe%3A%20%23NUM!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3279841%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1357431%22%20target%3D%22_blank%22%3E%40RishS2001%3C%2FA%3E%26nbsp%3BI'm%20pretty%20sure%20that%20%3CEM%3E%3CSTRONG%3En%3C%2FSTRONG%3E%20%3C%2FEM%3Emust%20be%20a%20whole%20number.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.