Prev: Cell formula that will give back the address of the cursor?
Next: Reverse string on multiply cells
From: Felicia Pickett on 24 Feb 2010 19:07
I have a billable rate of $70 with a mark up percentage of 17.65%. How do I
calculate the base rate?
From: Eva on 24 Feb 2010 19:44
Hi
70/1.1765
so
70/1.1765 = 59.5
59.5*17.65%=10.51+59.5=70

--
Please click "yes" if this post helped you!

Greatly appreciated

Eva


"Felicia Pickett" wrote:

> I have a billable rate of $70 with a mark up percentage of 17.65%. How do I
> calculate the base rate?
From: Fred Smith on 24 Feb 2010 22:44
(1+.1765)*X=70
X=70/(1.1765)
X=59.50

Regards,
Fred

"Felicia Pickett" <FeliciaPickett(a)discussions.microsoft.com> wrote in
message news:FB923CF3-3657-4D7C-8225-33F1A0A7227A(a)microsoft.com...
>I have a billable rate of $70 with a mark up percentage of 17.65%. How do I
> calculate the base rate?

From: Ashish Mathur on 28 Feb 2010 07:26
=17.65%/(1+17.65%)*70

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Felicia Pickett" <FeliciaPickett(a)discussions.microsoft.com> wrote in
message news:FB923CF3-3657-4D7C-8225-33F1A0A7227A(a)microsoft.com...
> I have a billable rate of $70 with a mark up percentage of 17.65%. How do
> I
> calculate the base rate?

 | 
Pages: 1
Prev: Cell formula that will give back the address of the cursor?
Next: Reverse string on multiply cells