Negative Percentages

[docjackson33]

I am using this formula in my spreadsheet =IFERROR(SUM(AQ5+AN5-AO5)/AP5,0) , but sometimes I get a negative %. What can I do to have a negative % just show 0%? If I need to post a partion of my spreadsheet I will...thanks in advance.

Jonathan

 

[Jonmo1]

Try

=IFERROR(MAX(0,SUM(AQ5+AN5-AO5)/AP5),0)

 

[Special-K99]

If((aq5+an5-ao5)/ap5<0,0,(aq5+an5-ao5)/ap5)

 

[docjackson33]

Perfect...thanks a lot.

 

[docjackson33]

This reminded me that not every time I use an "IF" statement, that it has to be "=" to something. I never thought to use < or >.

Thanks,

Jonathan