# formula for 1%

#### gilnic

##### New Member
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>

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
If C1 contains 1%, in B1 copied down:

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

Hello Andrew,
Thanks for prompt response.Worked well.

Replies
3
Views
135
Replies
7
Views
124
Replies
14
Views
270
Replies
0
Views
366
Replies
2
Views
127

1,203,686
Messages
6,056,737
Members
444,888
Latest member
Babi_mn

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back