=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