1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Why am I getting a #NUM error and how do I fix it?

https://preview.redd.it/m8pqx9rie7jg1.png?width=235&format=png&auto=webp&s=a0d1dcd31b1addb080b496ef3ad30ff97a1b0ecd

https://preview.redd.it/86477fzje7jg1.png?width=456&format=png&auto=webp&s=d98d551c1cf8e96846398d1b4b8f190fc9b155b5

https://preview.redd.it/arst41xke7jg1.png?width=80&format=png&auto=webp&s=ea8724009ed760774252bb22b25ed7eb139e0ea0

https://preview.redd.it/fl7it92me7jg1.png?width=252&format=png&auto=webp&s=7015f2d90858b20cbbbcb8e90446f0b6c8e02b0e

Basically what the title says, I'm just doing a number to the power of another number and yet I'm getting an error, I can't figure out what the issue is. I get a value when I use my physical calculator so it's not like it's an impossible result (like 1/0 or something). Doing -0.06^1/0.65 gives me an incorrect value (unsurprisingly) but if I simply put 1/0.65 in brackets I get the same error. Seriously no idea why it's not working. Thanks for any help.

submitted by /u/ItsSouper
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
##NUM error
#calculation error
#exponentiation
#brackets
#math operations
#physical calculator
#numerical result
#math error debugging
#result value
#calculator input
#number operations
#division by zero
#impossible result
#fixing errors
#user inquiry