Adding Max function to formula to enter 0 if <0

[O Wayne]

How can I do this without creating a circular reference?
Thanks,
Wayne

 

[Miguel Zapico]

What is what you are exactly doing? For that type of conditions, usually the
IF formula may help, but you haven't explained what you need to achieve and
where the circular reference arises.

Miguel.

 

[Guest]

Hi

Use something like this:
=MAX(0,yourformula)
If your formula is less than zero, this will return sero. If it's more than
zero, it will return the formula result

Hope this helps.
Andy.

 

[Jerry W. Lewis]

=If(MAX(data)<0,0,MAX(data))

Jerry