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