Division formula giving error message

Hi there - Whenever I try to do a basic division formula between the values in two columns I get an #ERROR! message. I can’t figure out why. Below is what I’m inputting.

Formula for column: {Measured Coil Temp.}/{Max Rated Temp.}

Would really appreciate some help. Thanks in advance!

Can you take a screen snip of your fields? It would save some potentially unnecessary question/answer back and forth.

1 Like

For sure. See attached.

To clarify, it shows #ERROR! when I actually input numbers into the “Measured Coil Temp” and “Max Rated Temp” fields too.

Hey Zaafir. You need to change your “Measured Coil Temp” and “Max Rated Temp” field types to Number (#)


1 Like

So simple. Can’t believe I missed that haha. Thank you!!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.