Thread
:
Want to calculate a percentage by dividing one cell by the other,
View Single Post
#
2
Nick Hodge
Posts: n/a
=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?
Reply With Quote