# Use Formula to Insert Fortnightly Payments in Table

#### XLReverseEngineering

##### New Member
Hello,

This is my first post and I'm hoping to get a bit of help with creating a formula that I can use on a finance table that I've created.

I am attempting to forecast my personal finances and want to insert fortnightly payments into a column automatically.

I've managed to do this for my monthly payments through using the following formula:=IF(\$J21=BJ\$14,BJ\$17,""). For context, \$J21 is the first cell of the column that captures the day value of the date which is in \$I21, BJ\$14 is the day of the month that the particular payment comes out (in this case the 4th) and BJ\$17 is the value of the payment (\$20). After entering this formula and dragging it down the entire column, \$20 appears whenever the date is the 4th of the month.

Does anyone know of a way that I could obtain the same result with fortnightly payments? Also, if you're feeling especially generous feel free to come up with a formula for quarterly payments too.

I've attached some screenshots, Screenshot A shows the columns that I want to insert the fortnightly payments into. Screenshot B shows what I have successfully done with the monthly payments.

My apologies if this is a silly question, I learn Excel by reverse engineering a lot of formulas that I come across in random spreadsheets (hence my display name). My knowledge definitely isn't up there at the moment and I might be missing something obvious.

Mr XL. R Engineering

#### Attachments

• Screenshot A.png
102.8 KB · Views: 18
• Screenshot B.png
125.6 KB · Views: 19

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### hernantorres23

##### Active Member
Hi, If you can share this workbook, without data, I'm sure I can help you, or put every sheet using add-in specifically for this and it can be found here XL2BB

Replies
5
Views
107
Replies
4
Views
267
Replies
5
Views
153
Replies
7
Views
129
Replies
9
Views
80

1,127,653
Messages
5,626,098
Members
416,161
Latest member
David1966Lewis

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