percentage

Posted by kydco on January 15, 2002 6:17 AM

How do I simply get a range of cells to generate a result of -30% of whatever is entered in the cell?

Posted by Barrie Davidson on January 15, 2002 6:20 AM

Assuming your data is in column A,

=A1*-0.3

and copy down. If you mean you want the result to be 30% less, change the formula to read

=A1*0.7

Regards,
BarrieBarrie Davidson

Posted by kydco on January 15, 2002 6:22 AM

Thanks!