Jump to content

Recommended Posts

  • Replies 78.7k
  • Created
  • Last Reply

Top Posters In This Topic

  • 'Dale

    4540

  • Hairy

    4308

  • gummibear

    3909

  • Eddy Gordo

    3867

Top Posters In This Topic

Posted

That's cos it's only recognising the 5% as an actual percentage. ie it's thinking 30-(2*5%) = 30-(2*0.05) = 30-0.1

 

EDIT: No, wait. It's expressing the percentages as a decimal. 0.02 * 0.05 = 0.001 which is 0.1%

 

Excel is a tricky bitch when it comes to percentages. As is the question, because if you do the calculation without dropping the percentages, it automatically reverts to the decimal equivalent, which corrupts the equation. 

excel is always right and thats all there is to it

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Settings My Forum Content My Followed Content Forum Settings Ad Messages My Ads My Favourites My Saved Alerts My Pay Deals Help Logout