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.

Need Help Making IF formula

Topic Labels: Formulas
Solved
Jump to Solution
956 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanya_Winograd
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all,

Can you please help me make a formula?
I have records with the following (relevant) columns:

  • Commission Processing Date (date format)
  • Income ($ format)
  • 1099 ($ format)

After a certain date, my Income needs to be adjust by -15% and that result should be listed under my 1099 column

Thus, I would like to do the following formula for my 1099 column: If Commission Processing is on or after 01/01/2020, then Income should be multiplied by 0.85. Otherwise, 1099 remains the same number as Income.

Can’t figure out how to do the date part of the IF formula. Thank you!

1 Solution

Accepted Solutions
Jason
Airtable Employee
Airtable Employee

Hi @Chanya_Winograd,

You can use the formula below for that calculation. Let me know if this helps!

IF(
   {Commission Processing Date} >= '01/01/2020',
   {Income} * 0.85, 
   {Income}
)

See Solution in Thread

1 Reply 1
Jason
Airtable Employee
Airtable Employee

Hi @Chanya_Winograd,

You can use the formula below for that calculation. Let me know if this helps!

IF(
   {Commission Processing Date} >= '01/01/2020',
   {Income} * 0.85, 
   {Income}
)