Skip to main content

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!

5 replies

Forum|alt.badge.img+18
  • Inspiring
  • 326 replies
  • February 16, 2021

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


  • Author
  • New Participant
  • 3 replies
  • February 16, 2021
augmented wrote:

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


For sure. See attached.


  • Author
  • New Participant
  • 3 replies
  • February 16, 2021
Zaafir_Ladha wrote:

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.


Forum|alt.badge.img+18
  • Inspiring
  • 326 replies
  • February 16, 2021
Zaafir_Ladha wrote:

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 (#)

Cheers!


  • Author
  • New Participant
  • 3 replies
  • February 16, 2021
augmented wrote:

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

Cheers!


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


Reply