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

=1-C4/C3

HTH,
Bernie
MS Excel MVP


"the_catster" wrote in message
...
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

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

=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" wrote in message
...
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