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.

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.

Thanks for the reply. I tried your formula but unfortunately it didn't work.
Maybe this explains my question a little better;

A1 + A2 = 0

If A2's value changes automatically adjust the value in A1 so the rusult
remains at 0.

"Gary''s Student" wrote:

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.

You won't be able to adjust A1 since you either enter data in the cell OR a
formula in the cell. The best you can do is calculate the value needed as
Gary's Student suggested and store this in another cell.

What you can do is take all of these calculated values copy them and then
Paste Special - Values Only over the orignial data. If you don't use the
Values Only, you will probably get a circular reference error.

"RDW" wrote:

Thanks for the reply. I tried your formula but unfortunately it didn't work.
Maybe this explains my question a little better;

A1 + A2 = 0

If A2's value changes automatically adjust the value in A1 so the rusult
remains at 0.

"Gary''s Student" wrote:

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.

I think this is what you are looking for;

=if(FORMULA IN CELL<0,0,FORMULA IN CELL)


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063
View this thread: http://www.excelforum.com/showthread...hreadid=534943