View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default To find out % of profit

=A2/A1-1
and format A3 like percent!
Regards,
Stefi

€˛pol€¯ ezt Ć*rta:

Hi all,

Please help to write a formula for the following case

A1 cell conatin cost value 500

A2 Cell contaain sales value 700

In A3 cell I have to find out the % of profit

With thanks

Polachan