Percentage problems
Hi,
Enter your value in A1. In B1 enter the number you wish
to express A1 as a percentage of (say 100). In C1 place
the following formula
=SUM(A1/B1)
Then format C1 as percentage.
When you say it doesn't work, what result are you getting?
Is the value in B1 ever 0? This will cause a DIV/0 error
-----Original Message-----
If I have a percentage in a column and in another I have
a
value (sometimes it is a minus value) and want to
calculate the value as a percentage I cant seem to get
it
to work.
Any ideas I have tried everything I can think of..
Thanks
.
|