|
Post by bungo the mungo on Dec 13, 2020 6:35:07 GMT
increase 240 by 15% and you get 276. decrease 276 by 15% and you get 234.6.
please can someone explain why there's a difference?
|
|
|
Post by Charlie O. on Dec 13, 2020 6:42:36 GMT
Because 15% of 240 is less than 15% of 276.
|
|
|
Post by hippopotamus on Dec 13, 2020 9:30:53 GMT
Great thread.
|
|
|
Post by bungo the mungo on Dec 13, 2020 9:50:59 GMT
ok. what would be the excel formula to find out what the start number would be with a 15% decrease that equals 20. i know it's something like 23.53, but i got there by luck rather than judgement.
as you can tell, maths is not my strong point, so happy to be shamed if it's easy.
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Dec 13, 2020 10:17:48 GMT
Why would it be an 'excel formula'? It's just a Maths formula isn't it?
|
|
rayge
Administrator
Invisible
Posts: 8,785
|
Post by rayge on Dec 13, 2020 10:37:58 GMT
I don't do Microsoft or Excel, but I did do arithmetic . If 20 is the number you end up with after taking 15% off the total, then 20 is 85%, or eighty-five hundreths, of the number you stared with, so to get back to it you need to multiply 20 by 100 and divide it by 85 (or multiply it by 20 and divide it by 17, same thing), so that means dividing 400 by 17, which as you say rounds to 23.53
|
|
|
Post by bungo the mungo on Dec 13, 2020 10:42:43 GMT
*sigh*
i'll explain my predicament. i'm self-employed and have to submit invoices to the companies i work for. normally, they give me a gross hourly rate and i then make a 15% deduction to get the net figure. easy. i use apple's numbers software to produce an invoice with formulas so that i just have to add in my hourly rate and the number of hours work, and hey presto, i get an accurate invoice.
i've started doing some work for a new company who have told me what my NET hourly rate is, so i have to find a formula whether it be an apple numbers formula or the maths formula which gives me the GROSS hourly rate.
|
|
|
Post by Mr. FOLLARD on Dec 13, 2020 10:42:55 GMT
(ask him about non-defining relative clauses - go on!)
|
|
|
Post by bungo the mungo on Dec 13, 2020 10:44:42 GMT
thank you, ray!
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Dec 13, 2020 10:46:50 GMT
* sigh* i'll explain my predicament. i'm self-employed and have to submit invoices to the companies i work for. normally, they give me a gross hourly rate and i then make a 15% deduction to get the net figure. easy. i use apple's numbers software to produce an invoice with formulas so that i just have to add in my hourly rate and the number of hours work, and hey presto, i get an accurate invoice. i've started doing some work for a new company who have told me what my NET hourly rate is, so i have to find a formula whether it be an apple numbers formula or the maths formula which gives me the GROSS hourly rate. What work is it?
|
|
|
Post by bungo the mungo on Dec 13, 2020 10:48:32 GMT
* sigh* i'll explain my predicament. i'm self-employed and have to submit invoices to the companies i work for. normally, they give me a gross hourly rate and i then make a 15% deduction to get the net figure. easy. i use apple's numbers software to produce an invoice with formulas so that i just have to add in my hourly rate and the number of hours work, and hey presto, i get an accurate invoice. i've started doing some work for a new company who have told me what my NET hourly rate is, so i have to find a formula whether it be an apple numbers formula or the maths formula which gives me the GROSS hourly rate. What work is it? teaching mathematics.
|
|
|
Post by cousinlou on Dec 13, 2020 13:24:53 GMT
Just divide 20 by 0.85.
Better advise: tell them what your hourly rate is instead of them telling you.
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Dec 13, 2020 13:29:50 GMT
Just divide 20 by 0.85. Better advise: tell them what your hourly rate is instead of them telling you. I think that only works if you're in a specialist position where you can offer some fairly unique skills/experience that are hard to find in the general work population.
|
|
|
Post by bungo the mungo on Dec 13, 2020 13:30:03 GMT
Just divide 20 by 0.85. Better advise: tell them what your hourly rate is instead of them telling you. cheers. all sorted now. i'm a bit of a div when it comes to maths. not too bad at English though. i think you meant to write 'advice'.
|
|
|
Post by Mr. FOLLARD on Dec 13, 2020 13:48:17 GMT
Just divide 20 by 0.85. Better advise: tell them what your hourly rate is instead of them telling you. I think that only works if you're in a specialist position where you can offer some fairly unique skills/experience that are hard to find in the general work population. Adam - you should go freelance instead of being tied to a language school.
|
|