formula for 1%

[gilnic]

Hello hoping someone can help with a formula please.
I have ColA which fluctuates up and down as per table. What I need to be able to do is in ColB have an amount of 1% of ColA. This has to be adjusted as the balances of ColA go up and down to 1% of the highest of column A. This is shown in the table.vWe start of with 50 being 1% and keep the 50 until the balance in the column increases as in 5400 then the 1% becomes 54 and stays until a new high is reached. The highest 1% is never decreased.

A	B
5000	50
4900	50
5400	54
5200	54
5800	58
6000	60
5500	60

<tbody>
</tbody>

 

[Andrew Poulsom]

If C1 contains 1%, in B1 copied down:

=MAX(A$1:A1)*C$1

 

[gilnic]

Hello Andrew,
Thanks for prompt response.Worked well.