Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Multiply Formula Error

Topic Labels: Formulas
758 1
Showing results for 
Search instead for 
Did you mean: 

Form some reason if I try to multiply or divide I get error however addition and subtraction works fine. What am i doing wrong?

Screen Shot 2020-02-27 at 8.04.31 am

1 Reply 1

Try wrapping them in a VALUE() function:

VALUE({Hold}) * VALUE({Dosage})

INT() will do the same thing, but returns an integer rather than a float.

Bit more info on this thread