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

Hi "Don" <anonymous@dis...,
What does it do instead of work?
What is the formula and associated data?
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Don" wrote in 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

Hi
and what's the basis for your percentage calculation?. You may post an
example (plain text please) and describe your expected result based on
this example

--
Regards
Frank Kabel
Frankfurt, Germany


Don wrote:
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

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
.

On Sun, 16 May 2004 11:25:15 -0700, "Matt Lunn"
wrote:

=SUM(A1/B1)

What is the purpose of the SUM worksheet function in your recommendation?

In other words, why not the simpler

=A1/B1

??




--ron