Remember Me?

#11
July 31st 09, 06:13 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 57
#Div/0

Thank you for all of the tips-- this works great -- sorry I had another post
out there I can't find it so I had to start over.. (my bad) ..

I didn't know if there is a way to see all of your posts?
"H" wrote:

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

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 01:20 AM.