Help

Formula and Calculation Help

Topic Labels: Formulas
Solved
Jump to Solution
442 2
cancel
Showing results for 
Search instead for 
Did you mean: 
MilhoanDesign
4 - Data Explorer
4 - Data Explorer

I am trying to solve the problem that I have illustrated in the image below. I am trying to create/calculate (see image) {Rate} and {Day Total}. In the below example, the first record for "Old Cypress - Weaned Calves," if the "Weaned Calves" == "Pasture" then pull in the value .70, and then multiply that value with the "Inventory" of 450. This will result in a "Day Rate" of $350. Any help will be appreciated! Thank you! 

airtable-formula-100.jpg

1 Solution

Accepted Solutions
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

@MilhoanDesign Put together a formula you can use to calculate the day rate. Also recorded a quick Loom Video to take you though step by step how I set it up. 

Table Structure:

Screenshot 2023-10-31 140433.png

Screenshot 2023-10-31 140446.png

Screenshot 2023-10-31 140505.png

 Day Rate Formula:

IF(
  {Location} = "Pasture",
  {Inventory} * {Pasture Rate},
  IF(
    {Location} = "On Hay",
    {Inventory} * {On Hay Rate},
    IF(
      {Location} = "On Windrow",
      {Inventory} * {On Windrow Rate}
    )
  )
)

 

See Solution in Thread

2 Replies 2
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

@MilhoanDesign Put together a formula you can use to calculate the day rate. Also recorded a quick Loom Video to take you though step by step how I set it up. 

Table Structure:

Screenshot 2023-10-31 140433.png

Screenshot 2023-10-31 140446.png

Screenshot 2023-10-31 140505.png

 Day Rate Formula:

IF(
  {Location} = "Pasture",
  {Inventory} * {Pasture Rate},
  IF(
    {Location} = "On Hay",
    {Inventory} * {On Hay Rate},
    IF(
      {Location} = "On Windrow",
      {Inventory} * {On Windrow Rate}
    )
  )
)

 

Arthur,

Thank you so very much for helping me out with this; I knew it had to be much simpler than what I was trying to do and this works perfectly! 

Thank you again! 

Walker