formula required

S

Super Joy

New Member
Joined
May 14, 2011
Messages
1
Hi,
I need to amortize an amount between the start and end months. Please can you get me a formula.


Start End Per Month May June July Aug Sept
June Aug 2000 2000 2000 2000 2000
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
Can you clarify your questions and align your sample data so I can see what you are trying to do and I will try and help.
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question Question
Spitting every 2000 rows of data to new workbook based on duplicate value
Replies
1
Views
94
Skyybot
Skyybot
A
  • Question Question
Excel - looking up data with multiple criteria from table/array, date must be same or nearest before the target cell
Replies
8
Views
612
Peter_SSs
Peter_SSs
A
  • Solved
If AND Formula Help
Replies
3
Views
346
dreid1011
dreid1011
T
  • Solved
How can I filter duplicates from a worksheet column out of a data validation list drop-down box?
Replies
5
Views
221
Peter_SSs
Peter_SSs
M
  • Question Question
Cell with 0 value showing blank
2
Replies
15
Views
755
mhessnm
M

Forum statistics

Threads
1,224,570
Messages
6,179,611
Members
452,931
Latest member
The Monk

Share this page

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