1,000,000.00 want 200,000.00 profit what is percentage

E

excell ferns

what is the formula if I want to establish the following
I have 1,000,000.00 and I want to make 200,000.00 in profit what will the
percentage be
 
G

Gord Dibben

Kinda short on details here ferns

=1,000,000 * .2 would return 200,000

=1,000,000 * 1.2 would return 1,200,000

Post back with how you intend to make the profit off the 1,000,000

Invest it? Buy something and re-sell it?

Gord Dibben Excel MVP

On Sat, 6 Nov 2004 17:26:01 -0800, excell ferns <excell
 
B

Bob Phillips

Divide the profit by the amount and format as a percentage.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top