Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to make a formula most of it works this is what I have so far =100%-(D62/C62) this part is great, but if D62=0 I want it to stay 0. How do I add to this formula to work?

share|improve this question

How about an If/then to check the value of D62?

=IF(D62=0,0,100%-(D62/C62))
share|improve this answer
    
THANK YOU, this one worked great. – Cris Jan 17 '12 at 17:04
    
@cris please mark it as the answer then. :) – WinOutreach4 Jan 17 '12 at 18:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .