=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
| 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
| >
| > | > | 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
| > | >
| > | > | > | > |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
| > | > | >
| > | > | > | > | > | > | 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
| > | > | >
| > | > | >
| > | > | >
| > | >
| > | >
| > | >
| >
| >
| >
