I need help determining which Excel formula to use for the following equation;
a+b=c when;
a=(c*65%)/0.5
b=600

Doesn't that just require juggling the components around

=(600*0.5)/35%

--

HTH

Bob

"davidsons4" wrote in message
...
I need help determining which Excel formula to use for the following
equation;
a+b=c when;
a=(c*65%)/0.5
b=600

Frankly, I'm a little rusty - but shouldn't it be:
= - 600 / (1.3-1)
which results: c = - 2000
Micky


"Bob Phillips" wrote:

Doesn't that just require juggling the components around

=(600*0.5)/35%

--

HTH

Bob

"davidsons4" wrote in message
...
I need help determining which Excel formula to use for the following
equation;
a+b=c when;
a=(c*65%)/0.5
b=600


.

What I meant was:
1.3c - c = - 600
0.3c = - 600
c = - 2000
Micky


"מיכ�ל (מיקי) �בידן" wrote:

Frankly, I'm a little rusty - but shouldn't it be:
= - 600 / (1.3-1)
which results: c = - 2000
Micky


"Bob Phillips" wrote:

Doesn't that just require juggling the components around

=(600*0.5)/35%

--

HTH

Bob

"davidsons4" wrote in message
...
I need help determining which Excel formula to use for the following
equation;
a+b=c when;
a=(c*65%)/0.5
b=600


.

This should be as:
=(600*100)/(100-32.5), which come to 888.88

"davidsons4" wrote:

I need help determining which Excel formula to use for the following equation;
a+b=c when;
a=(c*65%)/0.5
b=600

Well I'm not sure whether you are giving 888.88 as the answer for a or for b
or for c, and I'm not sure whether you are giving the answer to the subject
line which said
"if b=100 & a=(c*.65)/2 when a+b=c, what are b & c?"
or to the message content which said:
" a+b=c when;
a=(c*65%)/0.5
b=600"
but I don't think that 888.88 is the answer to any of the 6 questions.

If you look at "if b=100 & a=(c*.65)/2 when a+b=c, what are b & c?", a
=c*0.325, c*0.325 + 100 = c, hence c * (1 - 0.325) = 100, c =
100/(1-0.325), which is 148.148148..., and a is 48.148148...

If you look at " a+b=c when; a=(c*65%)/0.5; b=600" , a=c*1.3, c*1.3 + 600
= c, c*0.3 = -600, hence c = -2000 and a =-2600.

I don't see an 888.88 in there; have I got it wrong? I wonder whether you
are answering a mixture of the 2 questions?
--
David Biddulph


"Excel_Learner" wrote in message
...
This should be as:
=(600*100)/(100-32.5), which come to 888.88

"davidsons4" wrote:

I need help determining which Excel formula to use for the following
equation;
a+b=c when;
a=(c*65%)/0.5
b=600

but I don't think that 888.88 is the answer to any of <possible
combinations

Hi. I believe one gets 888.88 if you take b=600 from the message, and
take "/2" from the subject.

The Subject & body have two different equations.
= = = = =
Dana DeLouis


On 3/31/10 5:20 PM, David Biddulph wrote:
Well I'm not sure whether you are giving 888.88 as the answer for a or for b
or for c, and I'm not sure whether you are giving the answer to the subject
line which said
"if b=100& a=(c*.65)/2 when a+b=c, what are b& c?"
or to the message content which said:
" a+b=c when;
a=(c*65%)/0.5
b=600"
but I don't think that 888.88 is the answer to any of the 6 questions.

If you look at "if b=100& a=(c*.65)/2 when a+b=c, what are b& c?", a
=c*0.325, c*0.325 + 100 = c, hence c * (1 - 0.325) = 100, c =
100/(1-0.325), which is 148.148148..., and a is 48.148148...

If you look at " a+b=c when; a=(c*65%)/0.5; b=600" , a=c*1.3, c*1.3 + 600
= c, c*0.3 = -600, hence c = -2000 and a =-2600.

I don't see an 888.88 in there; have I got it wrong? I wonder whether you
are answering a mixture of the 2 questions?
--
David Biddulph


.com wrote in message
...
This should be as:
=(600*100)/(100-32.5), which come to 888.88

"davidsons4" wrote:

I need help determining which Excel formula to use for the following
equation;
a+b=c when;
a=(c*65%)/0.5
b=600

Yes. Hence the last sentence of my message.
--
David Biddulph


"Dana DeLouis" wrote in message
...
but I don't think that 888.88 is the answer to any of <possible
combinations

Hi. I believe one gets 888.88 if you take b=600 from the message, and
take "/2" from the subject.

The Subject & body have two different equations.
= = = = =
Dana DeLouis


On 3/31/10 5:20 PM, David Biddulph wrote:
Well I'm not sure whether you are giving 888.88 as the answer for a or
for b
or for c, and I'm not sure whether you are giving the answer to the
subject
line which said
"if b=100& a=(c*.65)/2 when a+b=c, what are b& c?"
or to the message content which said:
" a+b=c when;
a=(c*65%)/0.5
b=600"
but I don't think that 888.88 is the answer to any of the 6 questions.

If you look at "if b=100& a=(c*.65)/2 when a+b=c, what are b& c?", a
=c*0.325, c*0.325 + 100 = c, hence c * (1 - 0.325) = 100, c =
100/(1-0.325), which is 148.148148..., and a is 48.148148...

If you look at " a+b=c when; a=(c*65%)/0.5; b=600" , a=c*1.3, c*1.3 +
600
= c, c*0.3 = -600, hence c = -2000 and a =-2600.

I don't see an 888.88 in there; have I got it wrong? I wonder whether
you
are answering a mixture of the 2 questions?
--
David Biddulph


.com wrote in message
...
This should be as:
=(600*100)/(100-32.5), which come to 888.88

"davidsons4" wrote:

I need help determining which Excel formula to use for the following
equation;
a+b=c when;
a=(c*65%)/0.5
b=600