SOLVED

using If with other formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2684081%22%20slang%3D%22en-US%22%3Eusing%20If%20with%20other%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2684081%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings.%3C%2FP%3E%3CP%3EI%20need%20to%20do%20the%20following%3A%20Cell%20A1%20%26gt%3B%3D10000%2C%20%22cellA%20*20%25-2000%2C%20IF%20%26lt%3B%3D10000%20then%20%3Dcell%20A1%3C%2FP%3E%3CP%3EI%20hope%20you%20can%20make%20sense%20of%20what%20Im%20trying%20to%20do%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2684081%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2684141%22%20slang%3D%22en-US%22%3ERe%3A%20using%20If%20with%20other%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2684141%22%20slang%3D%22en-US%22%3ETry%20%3D%2BIF(A1%26gt%3B10000%2CA1*0.2-2000%2CA1)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2684185%22%20slang%3D%22en-US%22%3ERe%3A%20using%20If%20with%20other%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2684185%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1137314%22%20target%3D%22_blank%22%3E%40danlegrange%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20mean%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIF(A1%26gt%3B10000%2CA1*(1%2B20%25)-2000%2CA1)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New 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 (New 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