Equation to display combined results

[lemuel]

I can't figure out the right equation to use to display a result like this in a cell 1269 (3.48%).

1269 = the difference of 1st from 5th week
3.48% = percentage equivalent of the 1269/1stWeek

See attached xls.


thanks.

[Colin Legg]

Hi,

In my opinion it would be better to display each number in a separate cell. If you really want them in the same cell then, based on the calculation you described in your post, the formula would be like this:

Please Login or Register  to view this content.

[lemuel]

thanks for help.