Changing formula

[Davg]

I have a formula for which the value changes between 0 and a number greater than 0. What I need is for the formula in that cell, or a formula in another cell, to always return the number greater than 0 if it ever occurs.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[Trebor76]

Hi there,

Try this where the cell housing the amount is A2 (change to suit):

=IF(A2>0,A2,0)

HTH

Robert

 

[Davg]

Just tried that but it changes back to 0 once A2 changes to 0...
I guess this is because the logical test fails i.e. A2 is not > 0 so the false result is output i.e. 0

 

[Trebor76]

I guess this is because the logical test fails i.e. A2 is not > 0 so the false result is output i.e. 0

Correct. What you like the formula to return if the value is not greater than zero?

 

[Jonmo1]

Perhaps this thread will be helpfull

http://www.mrexcel.com/forum/showthread.php?t=562700&highlight=circular+reference

 

[Davg]

I think that's it! Thanks, the circular formula seems to be working. I didn't even know you could do circular formulas. Thanks again.