1
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?
Cris
Posted 2012-01-17T16:51:43.787
Reputation: 11
Microsoft Excel 2003 formulas
Answers
8
How about an If/then to check the value of D62?
=IF(D62=0,0,100%-(D62/C62))
Stevoni
Posted 2012-01-17T16:51:43.787
Reputation: 413
@cris please mark it as the answer then. :) – dwolters – 2012-01-17T18:39:38.000