up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

2 Answers

up vote 8 down vote

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

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

try this 

=IFERROR(100%-(D62/C62),0)

no error

with error

link|improve this answer
SRY this one made all of them zero – Cris Jan 17 at 17:01
Are you sure? This formula should return your number if D62/C62 doesn't cause error and return 0 if it cause error. For example, if D62 = 3 and C62 = 5 then it would return 0.4. If you change C62 to 0 it will cause an error #DIV/0! which will return 0 – chmod Jan 17 at 17:03
@chmod Iferror is an excel 2007/2010 function, it is not available in excel 2003. – Pynner Jan 17 at 17:52
mybad, I didn't realize that this function isn't available in 2003. Thank Pynner for pointing out. So I guess Stevoni answer is way to go. – chmod Jan 17 at 18:02
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.