withdrawal

  1. J

    Annuity draw-down over 25 years period

    Hi gurus, I will be very grateful if any one of you can assist on this. One of our team members who created the below has left the company and when we recover the file, we realised the formulas are totally gone! And none of us are able to work out the formula. Appreciate if any kind soul can...
  2. R

    Withdrawing balances from accounts

    Hi, Below are two banks, Bank A and Bank B where i am intending to withdraw based on the annual increase in withdrawal of 3% starting at age 70. Everthing works ok for me and and I provided the formula below that i am working on. However, I could not get the formula out for withdrawal. Given...
  3. K

    Color range on some condition with VBA

    Hi, I have data, and I want to color cell on the column B ("Deposit") and column C ("Withdrawal"), on some condition. Condition:- Rule 1 :- Deposit & withdrawal entry for same date and same amount - color code "green" Rule 2 :- Deposit & withdrawal entry for different dates with same amount...
  4. M

    MIN Function (or is there a better way)

    I am aware that the MIN function in Excel returns the min value in a defined range. What I’m trying to do is to return the min value of a rolling time period. Let me explain. I have two columns: date and withdrawals (in dollars). The date starts 10 years ago. Let’s just say the date range is...
  5. U

    countifs with date

    <tbody> Class Admission Withdrawal PG 11/16/17 PG 11/16/17 Nur 08/1/17 11/16/17 </tbody> Required answer <tbody> Class Admission Withdrawal PG 2 Nur 1 1 </tbody> Kindly Help
  6. M

    If F2 is -, then move that number to G2

    I have bank statements that have some withdrawals (column G) in the deposit column (F). See example below. Can you PLEASE help me get these -$ figures into column G?! THANK YOU!!! <colgroup><col><col><col><col><col><col span="3"></colgroup><tbody> Post Date Transaction Description Account...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top