I need an Excel formula for the following function "if value is less than or
greater than 0 adjust value in cell reference A1 to give a result of 0". I
know this can be achieved manually using Goal Seek but I was wondering if
this can be achieved automatically using a formula.