Function to change value in other cell?

[tehashi]

Hi;
I am trying to modify an If-Then formula i am using so that if part of it is true then it changes the value of another cell from 2 to 3.

This is my formula:

=IF(ISBLANK(AD2),IF(AC2<>"",IF(TODAY()>=(WORKDAY(AC2,7))+1,1,""),""),"")

I am trying to make it where if cell AD2 is not blank then it would change cell E2 from 2 to 3.

I cannot put a formula in E2 because that cell is manually changed sometimes, and i cannot for the life of me find how to export a value to another cell.

[contaminated]

I think it's not possible with worksheet function. U will need to use VBA code...

[tehashi]

Oh bullox...i don't know any VBA.

Well then, if there is not a function that could do the trick, does anyone know a VBA setup that would?