View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

=if(A1<=0,0,A1/B1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"KMHarpe" wrote in message
...
I want to calculate a percentage, but don't want it to calculate if the
cells
have a zero OR Negative numbers. How do I do this?