NEED AUTOMATICALLY CHANGED AMOUNT PERCENTAGE.

Closed
KITTU - Jul 3, 2015 at 02:20 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 3, 2015 at 03:04 PM
Hello,
I need to help to ms excel sheet


PERCENTAGE% 0.25 ENTER

AMOUNT PERCENTAGE%
25,000.00 AUMATICALLY CHANGE
300000 AUMATICALLY CHANGE
400000 AUMATICALLY CHANGE
500000 AUMATICALLY CHANGE


PERCENTAGE CELL ENTER DIFFERENT PERCENTAGES WE NEED AUTOMATICALLY CHANGED AMOUNT PERCENTAGE.


THANKS & REGARDS.

RAMAKRISHNA.M


1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 3, 2015 at 03:04 PM
KITTU, Good afternoon.

It is not clear exactly what you need.
But......

Suppose A1 --> 0.25%
then...
............A................B........
3....AMOUNT....PERCENTAGE
4......25000.....=FORMULA
5......30000.....=FORMULA
6......40000.....=FORMULA
7......50000.....=FORMULA

Try to use:
B4 --> =A4*$A$1

Copy it down.

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0