ExcelBanter - IF Function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Function? (https://www.excelbanter.com/excel-worksheet-functions/141800-if-function.html)

eXecutioner28

IF Function?

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

Niek Otten

IF Function?

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

eXecutioner28

IF Function?

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

Niek Otten

IF Function?

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

eXecutioner28

IF Function?

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

Niek Otten

IF Function?

eXecutioner28

IF Function?

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

Niek Otten

IF Function?

Dana DeLouis

IF Function?

Hi. If using Excel 2007, maybe...

=IFERROR(450/C9/D9,0)

Just a side note...Your examples have been dividing two cells.
However, with 450/C9/D9 you are actually multiplying them:
450 / (C9*D9)

Just throwing this out...did you mean: 450 / (C9/D9) ?
--
HTH :)
Dana DeLouis
Windows XP & Office 2007

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

eXecutioner28

IF Function?

All times are GMT +1. The time now is 08:21 AM.