Needing help with "IF-Or" formula in Excel 2007

Hello All : I'm having trouble figuring a formula.
Example:
Cell A1 is a Percentage Data Cell, all others are Numerical Cells.

Argument: If B1=0, or B2=0, or B2 =<0 then A1 needs to read 0%. Otherwise A1=B2/B1.

I'm not getting the Parent's. right or something. I'm getting a -% in A1 whereas it needs to be 0% or greater.

Thanks for any help.

Try this in A1:

=IF(B1=0,0,IF(B2<0,0,B2/B1))

Hope this helps.

Pete

Pete : Thanks so much ! Its working for me now. I wasn't aware you could repeat the "If" scenario multiple times in the same argument.

Thanks again !

Pete: How do I mark thread "solved" ?

It's called "nesting" of formulae - quite an important concept. You could also do it like this:

=IF(OR(B1=0,B2<0),0,B2/B1)

Thanks for the rep - to mark the thread as solved, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete