NEED AUTOMATICALLY CHANGED AMOUNT PERCENTAGE.

[Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
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 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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