Forum Discussion

danlegrange's avatar
danlegrange
Copper Contributor
Aug 25, 2021
Solved

using If with other formulas

Greetings. I need to do the following: Cell A1 >=10000, "cellA *20%-2000, IF <=10000 then =cell A1 I hope you can make sense of what Im trying to do
  • DKoontz's avatar
    Aug 25, 2021

    Try =+IF(A1>=10000,A1*0.2-2000,A1)