Forum Discussion
danlegrange
Aug 25, 2021Copper Contributor
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
Try =+IF(A1>=10000,A1*0.2-2000,A1)
3 Replies
- SergeiBaklanDiamond Contributor
- DKoontzSteel Contributor
Try =+IF(A1>=10000,A1*0.2-2000,A1)
- danlegrangeCopper ContributorThanks bud, worked like a dream