Help

The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

Re: Division formula giving error message

1225 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Zaafir_Ladha
4 - Data Explorer
4 - Data Explorer

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 5
augmented
10 - Mercury
10 - Mercury

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

For sure. See attached.

Screen Shot 2021-02-16 at 1.32.20 PM

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!

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