Simple Sum ?! Percentage of a value

[PacificQuest]

Afternoon,

C1 = Number Value and C2 = Number Value, I would like C3 to show the percentage that C2 is of C1.

Math way would be C2-C1/C1 but I can't get it to work in Excel?

Thanks,
PQ

 

[VoG]

Try

=(C2-C1)/C1

 

[JackDanIce]

As an alternative, you could use:

=C2/C1-1

Same as Peter's code but multiplying out the brackets - all depends on your preference/understanding