Airtable Team Plan Pricing Inquiry

[Admin_LI]

Hi! I thought a simple formula shown below would calculate price per square foot for my table.

{Price} / {Building SqFt}

Both Price and BuildingSqFt are columns in my table, so I am not sure why the formula gives me an ERROR response. What formula do I need instead?

Thank you!

[kuovonne]

Can you post a screenshot that shows the field types? I’m guessing that at least one of those fields is not a number field, even if it looks like a number. 

[Shawn_Peters]

1-Ensure values exist for the sqft as dividing by zero is not viable,  but can be bypassed wrapping the formula in an if statement IF ({Building SqFt},{Price} / {Building SqFt}) .

It may also be a matter of declaring the values to be float or int type prior to calculation