Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 21st 09, 06:49 PM posted to microsoft.public.excel.newusers
H H is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 57
Default #Div/0

Hi - is there a way to avoid getting this result #DIV/0? Can I divide and get
a line or something instead when there is nothing to divide by?

=B5/A5?

Thank you

  #2   Report Post  
Old July 21st 09, 06:51 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
Default #Div/0

=IF(A5=0,"",B5/A5)

"H" wrote in message
...
Hi - is there a way to avoid getting this result #DIV/0? Can I divide and
get
a line or something instead when there is nothing to divide by?

=B5/A5?

Thank you


  #3   Report Post  
Old July 21st 09, 06:56 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default #Div/0

Hi
=if(a5="","",B5/A5)

"H" wrote:

Hi - is there a way to avoid getting this result #DIV/0? Can I divide and get
a line or something instead when there is nothing to divide by?

=B5/A5?

Thank you

  #4   Report Post  
Old July 21st 09, 10:06 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,204
Default #Div/0

Here's one that's even more generic, but a little more dangerous - it
disregards virtually all errors, including divide by zero:
=IF(ISERR(B5/A5),"",B5/A5)
note that you can put something in there to show when it did have a problem
(most likely a divide by zero:
=IF(ISERR(B5/A5),"---",B5/A5)


"H" wrote:

Hi - is there a way to avoid getting this result #DIV/0? Can I divide and get
a line or something instead when there is nothing to divide by?

=B5/A5?

Thank you

  #5   Report Post  
Old July 22nd 09, 04:43 PM posted to microsoft.public.excel.newusers
H H is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 57
Default #Div/0

Hey thanks -- is there a way to do something like this for - I'm getting the
#Div/0 on a few cuz T is 0
=+(X2/T2)*12

"JLatham" wrote:

Here's one that's even more generic, but a little more dangerous - it
disregards virtually all errors, including divide by zero:
=IF(ISERR(B5/A5),"",B5/A5)
note that you can put something in there to show when it did have a problem
(most likely a divide by zero:
=IF(ISERR(B5/A5),"---",B5/A5)


"H" wrote:

Hi - is there a way to avoid getting this result #DIV/0? Can I divide and get
a line or something instead when there is nothing to divide by?

=B5/A5?

Thank you



  #6   Report Post  
Old July 22nd 09, 06:20 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2,059
Default #Div/0

"H" wrote:
is there a way to do something like this for - I'm getting the
#Div/0 on a few cuz T is 0
=+(X2/T2)*12


=if(T2=0, "", 12*X2/T2)

That results in a cell that appears blank if T2 is zero. Alternatively,
replace "" with anything else you wish, for example 0.

  #7   Report Post  
Old July 22nd 09, 08:58 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default #Div/0

Hi,

I second Bob's comment on your other post - please post a question to only
one newgroup at a time.

You have plenty of answers between your two post, but let me encourage you
not to use the
=+(X2/T2)*12 syntax

First you don't need both = and + and in fact you should use only = to start
your formulas. =- is OK but not =+ It doesn't affect the formula results
but it is extra typing, takes extra memory, and is bad style.

Second =X2/T2*12 does the same calculation as your. So the parentheses are
not necessary here.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"H" wrote:

Hey thanks -- is there a way to do something like this for - I'm getting the
#Div/0 on a few cuz T is 0
=+(X2/T2)*12

"JLatham" wrote:

Here's one that's even more generic, but a little more dangerous - it
disregards virtually all errors, including divide by zero:
=IF(ISERR(B5/A5),"",B5/A5)
note that you can put something in there to show when it did have a problem
(most likely a divide by zero:
=IF(ISERR(B5/A5),"---",B5/A5)


"H" wrote:

Hi - is there a way to avoid getting this result #DIV/0? Can I divide and get
a line or something instead when there is nothing to divide by?

=B5/A5?

Thank you

  #8   Report Post  
Old July 22nd 09, 11:51 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2,059
Default #Div/0

"Shane Devenshire" wrote:
Second =X2/T2*12 does the same calculation as your.
So the parentheses are not necessary here.


Well, if we're nitpicking style....

I wholly agree with deprecating unneeded parentheses when they encumber
readability.

But I would say that 12*X2/T2 is better than X2/T2*12 in most contexts.

Even though they are functionally equivalent, thanks to the equal precedence
of / and *, I would say that X2/T2*12 is easy to misinterpret, and it is
easy to raise questions about the intent ( X2/(T2*12)? ).

If I were to express X2/T2*12 in that order, I would either write X2/T2 * 12
(added spacing) or, in fact, (X2/T2)*12.


----- original message -----

"Shane Devenshire" wrote in
message ...
Hi,

I second Bob's comment on your other post - please post a question to only
one newgroup at a time.

You have plenty of answers between your two post, but let me encourage you
not to use the
=+(X2/T2)*12 syntax

First you don't need both = and + and in fact you should use only = to
start
your formulas. =- is OK but not =+ It doesn't affect the formula results
but it is extra typing, takes extra memory, and is bad style.

Second =X2/T2*12 does the same calculation as your. So the parentheses
are
not necessary here.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"H" wrote:

Hey thanks -- is there a way to do something like this for - I'm getting
the
#Div/0 on a few cuz T is 0
=+(X2/T2)*12

"JLatham" wrote:

Here's one that's even more generic, but a little more dangerous - it
disregards virtually all errors, including divide by zero:
=IF(ISERR(B5/A5),"",B5/A5)
note that you can put something in there to show when it did have a
problem
(most likely a divide by zero:
=IF(ISERR(B5/A5),"---",B5/A5)


"H" wrote:

Hi - is there a way to avoid getting this result #DIV/0? Can I divide
and get
a line or something instead when there is nothing to divide by?

=B5/A5?

Thank you


  #9   Report Post  
Old July 30th 09, 11:23 PM posted to microsoft.public.excel.newusers
H H is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 57
Default #Div/0

what about this when one of the columns has #div/0
=+((X807/T807)*12)/V807

"JoeU2004" wrote:

"Shane Devenshire" wrote:
Second =X2/T2*12 does the same calculation as your.
So the parentheses are not necessary here.


Well, if we're nitpicking style....

I wholly agree with deprecating unneeded parentheses when they encumber
readability.

But I would say that 12*X2/T2 is better than X2/T2*12 in most contexts.

Even though they are functionally equivalent, thanks to the equal precedence
of / and *, I would say that X2/T2*12 is easy to misinterpret, and it is
easy to raise questions about the intent ( X2/(T2*12)? ).

If I were to express X2/T2*12 in that order, I would either write X2/T2 * 12
(added spacing) or, in fact, (X2/T2)*12.


----- original message -----

"Shane Devenshire" wrote in
message ...
Hi,

I second Bob's comment on your other post - please post a question to only
one newgroup at a time.

You have plenty of answers between your two post, but let me encourage you
not to use the
=+(X2/T2)*12 syntax

First you don't need both = and + and in fact you should use only = to
start
your formulas. =- is OK but not =+ It doesn't affect the formula results
but it is extra typing, takes extra memory, and is bad style.

Second =X2/T2*12 does the same calculation as your. So the parentheses
are
not necessary here.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"H" wrote:

Hey thanks -- is there a way to do something like this for - I'm getting
the
#Div/0 on a few cuz T is 0
=+(X2/T2)*12

"JLatham" wrote:

Here's one that's even more generic, but a little more dangerous - it
disregards virtually all errors, including divide by zero:
=IF(ISERR(B5/A5),"",B5/A5)
note that you can put something in there to show when it did have a
problem
(most likely a divide by zero:
=IF(ISERR(B5/A5),"---",B5/A5)


"H" wrote:

Hi - is there a way to avoid getting this result #DIV/0? Can I divide
and get
a line or something instead when there is nothing to divide by?

=B5/A5?

Thank you



  #10   Report Post  
Old July 31st 09, 01:02 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2,059
Default #Div/0

"H" wrote:
what about this when one of the columns has #div/0
=+((X807/T807)*12)/V807


Use JLatham's generic solution (well, almost), namely:

=if(iserror(12*X807/T807/V807), 0, 12*X807/T807/V807)

or

=if(iserror(12*X807/T807/V807), "", 12*X807/T807/V807)

See the help page for Is Functions for the difference between ISERR and
ISERROR. It's a judgment call.

Caveat emptor: If you start returning "" in some cells, it would be prudent
to allow for references to such cells in your formulas. So:

=if(iserror(12*n(X807)/n(T807)/n(V807)), "", 12*n(X807)/n(T807)/n(V807))


----- original message -----

"H" wrote in message
...
what about this when one of the columns has #div/0
=+((X807/T807)*12)/V807

[.....]
"JLatham" wrote:

Here's one that's even more generic, but a little more dangerous -
it
disregards virtually all errors, including divide by zero:
=IF(ISERR(B5/A5),"",B5/A5)
note that you can put something in there to show when it did have a
problem
(most likely a divide by zero:
=IF(ISERR(B5/A5),"---",B5/A5)


"H" wrote:

Hi - is there a way to avoid getting this result #DIV/0? Can I
divide
and get
a line or something instead when there is nothing to divide by?

=B5/A5?

Thank you




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017