Oh, this is great... thanks a lot, it works like I imagined...

thanks again

bye

Korisnik "Niek Otten" napisao je:

=IF(OR(C9=0,D9=0),0,450/C9/D9)

Just check each divider and if any of them is zero, return zero

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"eXecutioner28" wrote in message
...
| ok, thanks but what if i have like this:
| C9 - 0
| D9 - 0
|
| and in E9 I have formula like this: =450/C9/D9. Is it possible to get 0 and
| not this #DIJ/0!. Can you explain the process?
|
| thank you very much
|
| bye
|
|
| Korisnik "Niek Otten" napisao je:
|
| In E1:
|
| =IF(D1=0,0,C1/D1)
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "eXecutioner28" wrote in message
| ...
| | 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
| | |
| | |
| | |
| |
| |
| |
|
|
|