Modifying formula that keeps expanding within the cell

  • I have a formula that works fine but am trying to modify and every time i do it expands within the cell I dont know why this happens. The formula expands withing the cell every time I attempt to modify the 190 to 360. an example is like in H5.


    HTML
    =IF(ISERROR(FIND("*",D3,1)),IF(DATEVALUE(RIGHT(D3,2) &"/" & LEFT(D3,4))<DATE(YEAR(TODAY()),MONTH(TODAY()),1),"ASAP",IF(DATEVALUE(RIGHT(D3,2) &"/" & LEFT(D3,4))<DATE(YEAR(TODAY()),MONTH(TODAY()),1)+190,"Select me","")),"RESEARCH")

Participate now!

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