Formula cleansing

[MrFinance1]

Hi,

Does anyone know a cleaner way to incorporate a quarterly recurring cost in a monthly cash flow setting? What I do currently is =IF(OR(C3=3,C3=6,C3=9,C3=12 and so forth) but there must be a more sensible method.

Any help much appreciated.

Thanks

 

[Marcelo Branco]

Welcome to Mr Excel Forum

Maybe...
=IF(MOD(C3,3)=0,...

M.