=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