multi formulas in excel

T

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
 
N

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
 
Top