Division formula giving error message

[Zaafir_Ladha]

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!

[augmented]

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

[Zaafir_Ladha]

For sure. See attached.

[Zaafir_Ladha]

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

[augmented]

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

Cheers!

[Zaafir_Ladha]

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