ok, but what if in C1 value is 5 and in D1 is 0, then cell E1(C1/D1) is
returning #DIJ/0! and I would like it to return 0. Is that possible?

Korisnik "Niek Otten" napisao je:

That is what I meant:

=IF(B1=0,0,A1/B1)

If B1 is zero, the formula will return zero, otherwise it will return A1/B1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"eXecutioner28" wrote in message
...
|I want to do this then, to divide like this 5/0 and to get 0 and not #DIJ/0.
| Is this possible? please anwser asap
|
| thanks
|
| Korisnik "Niek Otten" napisao je:
|
| You can't store infinite in Excel; the max number is 9.99999999999999E+307
| But maybe you mean to avoid division by zero:
|
| =IF(B1=0,0,A1/B1)
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "eXecutioner28" wrote in message
| ...
| | Hi,
| |
| | I have two cells, and I divide them, but need to set another cell that
| | would: if the number for the divides cells is infinite that it would show 0.
| | How to put "infinite" into if function? or is there another, better one?
| |
| | thanks
|
|
|