300000 Vietnam Dong">
SOLVED

Help me with this formula. Im trying to do the "discount when the sum is >300000 Vietnam Dong

%3CLINGO-SUB%20id%3D%22lingo-sub-1944148%22%20slang%3D%22en-US%22%3EHelp%20me%20with%20this%20formula.%20Im%20trying%20to%20do%20the%20%22discount%20when%20the%20sum%20is%20%26gt%3B300000%20Vietnam%20Dong%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1944148%22%20slang%3D%22en-US%22%3E%3CP%3E%3DIF(SUM(E3%3AE6)%26gt%3B300000%2CSUM(E3%3AE6)%3A10%2F100%2CSUM(E3%3AE6)%3C%2FP%3E%3CP%3EIt%20keep%20showing%20error%20at%20the%20%26gt%3B300000%20%3A%26lt%3B%26lt%3B%26lt%3B%3C%2FP%3E%3CP%3EAnd%20btw%20dong%20is%20Vietnamese%20currency%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1944148%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-1944275%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20me%20with%20this%20formula.%20Im%20trying%20to%20do%20the%20%22discount%20when%20the%20sum%20is%20%26gt%3B300000%20Vietnam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1944275%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F886919%22%20target%3D%22_blank%22%3E%40StudentOfStupid%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20have%20seen%20your%20parentheses%20are%20closed%20incorrectly%20%26amp%3B%20you%20cannot%20add%20%22%3A%22%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EIF(SUM(E3%3AE6)%26gt%3B300000%2CSUM(E3%3AE6)*(10%2F100)%2CSUM(E3%3AE6))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20still%20facing%20the%20issue%20share%20your%20desired%20output%20entered%20manually%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1944431%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20me%20with%20this%20formula.%20Im%20trying%20to%20do%20the%20%22discount%20when%20the%20sum%20is%20%26gt%3B300000%20Vietnam%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1944431%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3BYou're%20almost%20right%20because%20it%20said%20discount%2010%25%20so%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(SUM(E3%3AE6)%26gt%3B300000%2CSUM(E3%3AE6)-SUM(E3%3AE6)*(10%2F100)%2CSUM(E3%3AE6))%3C%2FP%3E%3CP%3Eis%20the%20most%20correct%20but%20you%20give%20me%20the%20idea%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

=IF(SUM(E3:E6)>300000,SUM(E3:E6):10/100,SUM(E3:E6)

It keep showing error at the >300000 :<<<

And btw dong is Vietnamese currency

3 Replies
best response confirmed by StudentOfStupid (New Contributor)
Solution

Hi @StudentOfStupid 

 

What I have seen your parentheses are closed incorrectly & you cannot add ":" 

 

IF(SUM(E3:E6)>300000,SUM(E3:E6)*(10/100),SUM(E3:E6))

 

If you are still facing the issue share your desired output entered manually

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

@Faraz Shaikh You're almost right because it said discount 10% so 

=IF(SUM(E3:E6)>300000,SUM(E3:E6)-SUM(E3:E6)*(10/100),SUM(E3:E6))

is the most correct but you give me the idea