Complex IF function help

[excelos]

Hello!

I have a formula that does a mathematical operation and it's part of a parent IF formula (the if not value). How do I make this 'if not value' to appear as zero when the result of the mathematical function is negative?

Thanks!

 

[Eric W]

...result...

==>

...MAX(result,0)...

 

[dreid1011]

Could you post the formula you are using? You COULD use something like this, but I'm not quite sure of your formula structure:

=IF( logical test, true result, MAX(0, mathematical operation))