• Answers
  • Web
Answer 1 out of 1
 
10 helpful answers
A:

=if(divider=0; 0; value/divider)

If(truth test ;if truth test is true value in cell is this ; if truth test is not true formula in cell is this (your actual formula goes here)

So, you can make a formula that will first test divider. If it is zero, the answer will be 0. If divider is any other value than zero, formula will count you're actual calculation.

Helped you any?

Posted 2 years ago
EscApe was invited by Yedda to answer this question.

Helpful?(2)
Rated as Best Answer
 
Comment About This Answer (or add your own answer)

Feed - Subscribe to changes to this Q&A Blog
ADVERTISEMENT
  • Answers
  • Web
Copyright © 2006-2009, Yedda Inc. and respective copyright owners