Help

Need Help Making IF formula

Topic Labels: Formulas
Solved
Jump to Solution
545 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}
)