Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Multiplying price / quantity

Topic Labels: Formulas
Solved
Jump to Solution
3353 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Caleb_Dicks
4 - Data Explorer
4 - Data Explorer

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?

Screenshots

1 Solution

Accepted Solutions
SDOK_Blog
6 - Interface Innovator
6 - Interface Innovator
5 Replies 5
SDOK_Blog
6 - Interface Innovator
6 - Interface Innovator

HI.
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

Screenshots

SDOK_Blog
6 - Interface Innovator
6 - Interface Innovator

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

SDOK_Blog
6 - Interface Innovator
6 - Interface Innovator

Screenshot%20from%202019-09-08%2018-27-06

That worked, Thank you