Hi rapscalli,
Welcome to the forum.
Use the below formula in cell D2 and drag it to right and down....
=IF(AND(D$1>=$B2,D$1<=$C2),$A2/(($C2-$B2)+1),2)
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi rapscalli,
Welcome to the forum.
Use the below formula in cell D2 and drag it to right and down....
=IF(AND(D$1>=$B2,D$1<=$C2),$A2/(($C2-$B2)+1),2)
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks