300000 Vietnam Dong">
SOLVED

New Contributor

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

=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

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

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.

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

@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

95% idea oops