# MOD(ROWS() Function

• Hi Guys and Gals.

Attached is an excel spreadsheet showing the following

Col A - Week No

Col B - Date

Col C - Payment

Col D - Every nth Weeks

Col F - Fixed Payment

So what I'm looking for is a formula in Col C, Where I receive a fixed payment of \$20 (Col F) the day following 12 Weeks (Col D) up to just before the following payment. Then The next payment run starts a day after week 24 (accumulative) and so on. Hope I explained this OK. But I have manually filled in the required numbers to show what is required.

## Files

• Maybe,

1] C5, keep empty

2] In C6, formula copied down to C57 :

=IFERROR(1/(1/(INT((ROW(A1)-1)/D\$5)*F\$5)),"")

Regards

• Hi Bosco

Thanks. But the formula inserts 4, 8, 12, & 16 instead of the dollar values 20, 40, 60 & 80. Any idea what to do?

• Nevermind. Sorted it out. Thanks a lot. It works

• Oh come on dude. As per Bosco post

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!