Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Need Help Making IF formula

Topic Labels: Formulas
Solved
Jump to Solution
254 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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}
)