Using multiple If statements with a negative percentage number

You could use this in E9:

=IF(E4=0,"",IF(OR(E6>=0.125%,E6<=-0.125%),"Yes, a new Pre-TIL should have been sent out.","No, a new Pre-TIL is not necessary"))

Another way would be to use ABS(E6) in your first formula.

Hope this helps.

Pete