Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Multiplying price / quantity

Topic Labels: Formulas
Jump to Solution
1212 5
Showing results for 
Search instead for 
Did you mean: 

I am trying to make a grocery list that would take the price of an item ($0.88) and multiply it by the quantity needed (2) so that it outputs the total amount ($1.76)

I have tried the formula Price * Quantity which hasn’t worked.

How would i create a formula to output the total price as stated above?


1 Solution

Accepted Solutions
5 Replies 5

What error do you have?
It should work.
Look at your field types:
it should be number or currency for prices, and number for quantity.

Price is set as a currency field and Quantity is set as a numeric field.

when i input the formula

Price * Quantity

the formula outputs an integer when i am expecting a currency


Change the “formating” in airtable formula field to “currency”

6 - Interface Innovator
6 - Interface Innovator


That worked, Thank you