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

[StudentOfStupid]

=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

[#2 · Accepted 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.

[#3]

@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

[#4]

95% idea oops