Excel problem (possible or not to solve it) - I need help!?

2 ⤊

Excel problem (possible or not to solve it) - I need help!?

I have a problem with "% of increase" function - when I use 0 as a dividor, Excel shows me an error.

OK, I know it's logical, but I would like to make something like exclusion of that rule. Is it possible to make Excel (actually cell function) to show 0% instead of error in this case?

Thanx.

2006-09-20 02:59:06 · 2 answers · asked by Anonymous in Computers & Internet ➔ Software

2 answers

=IF(dividor <> 0, "% of increase", "0")

2006-09-20 03:05:26 · answer #1 · answered by teef_au 6 · 2⤊ 0⤋

I don't know exactly what function you are using, but you might try this. Since it is mathematical incorrect, why not try using 10,000,000 or some other large number that will not create a very wrong answer?

2006-09-20 10:10:23 · answer #2 · answered by Joseph G 3 · 0⤊ 1⤋