| 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 | | | | | | | | | |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | | | | | | | | | |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function?
=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 | | | | | | | | | | | | | | | | | | |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | | | | | | | | | |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function?
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 | | | | | | | | | | | | | | | | | | |
| 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 | |||
Linear Mode
