Hello!
Good day! Pls. i'm having trouble adding a formula to put a value every 3 months inside the formula. I have other formula inside but if I add the formula for adding the every 3 months, it is giving me an error.
=IF(BW3<>0,BW3,0)*0+IF(SUM($BV3:BW3)>0,IF(SUM($BV3:BW3)<1.01,$BN3,0))*0+IF(BW$2>=$BJ$3,IF(MOD(MONTH(BW$2)-MONTH($BJ$3),3)=0,$BO$3,"0"),"")
Appreciate your help pls.
Attached is the file.
Thanks in advance.
Bookmarks