Forum Discussion

NDCS_2022's avatar
NDCS_2022
Copper Contributor
Jul 07, 2022

Can't get excel formula correct

I'm trying to follow the below youtube tutorial on creating a Gantt chart in excel, but am stuck on the formula detailed at minute 12:30. This is what I have and it looks right when I compare to the formula in the video, but no matter what I try, it's not working: =AND($16>0, K$4 <= ($E6+($F6-$E6)*$16)-WEEKDAY(($E6+($F6-$E6)*$16),2)+1, K$4 >= $E6 - WEEKDAY($E6, 2)+1)

 

https://youtu.be/tuQpGzL_14g

 

Help please!

  • NDCS_2022 

    It's not $16 but $I6 with upper case i after the $ sign:

     

    =AND($I6>0, K$4 <= ($E6+($F6-$E6)*$I6)-WEEKDAY(($E6+($F6-$E6)*$I6),2)+1, K$4 >= $E6 - WEEKDAY($E6, 2)+1)

  • NDCS_2022 

    It's not $16 but $I6 with upper case i after the $ sign:

     

    =AND($I6>0, K$4 <= ($E6+($F6-$E6)*$I6)-WEEKDAY(($E6+($F6-$E6)*$I6),2)+1, K$4 >= $E6 - WEEKDAY($E6, 2)+1)

Resources