In cell A2 enter:
=IF(A1<=0,0,123)

just replace 123 with whatever value you desire
--
Gary's Student


"RDW" wrote:

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.