Subtract 20 repeatedly from an original value until the value reaches zero

I am a professed excel noob and so I need help writing this function. I need to write a function where a column of values will subtract from an original value until the value reaches zero.

If my original value is 125, I need the following table to look like this

B1 20
B2 20
B3 20
B4 20
B5 20
B6 20
B7 5

I need the function to be generic so that I can start with any original value and the function will show 20 in the column cells until the value reaches less than 20 in the final cell.

hope this makes sense.

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Enter formula in A3 and copy down

Formula:

Please Login or Register  to view this content.

v	A	B
1	125	Total Amount
2	20	Min
3	20
4	20
5	20
6	20
7	20
8	5
9

excel_noob14,

You have put this same problem on another site and it has already been fixed.

https://www.mrexcel.com/forum/excel-...ml#post5016282

When you do this let people know that you asked the same question on another site as well.

Forum Rule
8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

We hope you understand.

Have a nice day!

Thank you for your thread title. As you have also cross-posted without telling us, please take a moment to read our forum rules: there are not many, but we must ALL abide by them for the benefit of all who post here.

Thank you for your co-operation.