multi formulas in excel

[the_catster]

Please help, I'm trying to show margin or profit on a spread sheet the
formula I am using example:
=C4/C3 Where c4 equals 300.00 and c3 equals 100.00 answer is 33.3% but what
I want is the inverse or 66.7% I have tried =C4/C3-1 but this gives me -66.7%
I need the answser to be positive, example 66.7

[Bernie Deitrick]

=1-C4/C3

HTH,
Bernie
MS Excel MVP


"the_catster" <the_catster@discussions.microsoft.com> wrote in message
news:0710DB8F-C669-4BFF-99F2-93E46850ACEA@microsoft.com...
> Please help, I'm trying to show margin or profit on a spread sheet the
> formula I am using example:
> =C4/C3 Where c4 equals 300.00 and c3 equals 100.00 answer is 33.3% but
what
> I want is the inverse or 66.7% I have tried =C4/C3-1 but this gives
me -66.7%
> I need the answser to be positive, example 66.7

[Duke Carey]

Shouldn't this simply be

=(C4-C3)/C4

"the_catster" wrote:

> Please help, I'm trying to show margin or profit on a spread sheet the
> formula I am using example:
> =C4/C3 Where c4 equals 300.00 and c3 equals 100.00 answer is 33.3% but what
> I want is the inverse or 66.7% I have tried =C4/C3-1 but this gives me -66.7%
> I need the answser to be positive, example 66.7

[Niek Otten]

=1-(C3/C4)

BTW you got 33.3% from 100/300, not the way you suggest

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"the_catster" <the_catster@discussions.microsoft.com> wrote in message
news:0710DB8F-C669-4BFF-99F2-93E46850ACEA@microsoft.com...
> Please help, I'm trying to show margin or profit on a spread sheet the
> formula I am using example:
> =C4/C3 Where c4 equals 300.00 and c3 equals 100.00 answer is 33.3% but
> what
> I want is the inverse or 66.7% I have tried =C4/C3-1 but this gives
> me -66.7%
> I need the answser to be positive, example 66.7