| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | | | |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | | | |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function?
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 | | | | | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Hybrid Mode
