SOLVED

using If with other formulas

Copper Contributor

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

3 Replies
best response confirmed by danlegrange (Copper Contributor)
Solution

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

@danlegrange 

Perhaps you mean

=IF(A1>10000,A1*(1+20%)-2000,A1)
Thanks bud, worked like a dream
1 best response

Accepted Solutions
best response confirmed by danlegrange (Copper Contributor)
Solution

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

View solution in original post