Adding floating point numbers
the value 0.1 in the computer memory is not equal 0.1 so if u add it 10
times the result is diffrent then 1.0:
double value=0.1, result;
float value=0.1, result;
can anyone explain it?
On Thu, 28 Jun 2007 10:18:05 -0700, rsobies
>the value 0.1 in the computer memory is not equal 0.1...True or False Formula?
Hi Everyone. I've just got myself Excel and I'm trying to create a simple
What I need to do is have C calculated automatically. I have searched Google
for a hint, but I don't know Excel that well enough yet plus English is my
If A is greater than B, C is the answer.
1>1=Equal or 0 from what I read
Very much thanks to anyone who can help learn this.
Hello. I have worked out part of my probelm and realized I need help with
more. I am trying to learn this.
...Non-VBA formula to find 2nd Sunday of a given month
Can anyone help me write a formula to find the date of the second sunda
in a given month?
Thanks in Advance,
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
Assuming you have a date in A1, this gives the 2nd Sunday of that date
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"DavidObeid&q...adding items to the action pane in GP 10
We need to offer the capability to add additional windows to the "Go To"
button in the Action Panes, beyond the (very) limited options currently
available. For example, in the Accounts view of the Financial Center, there
is no way to Add to the "Go To" a link to the "Actual vs. Budget Inquiry
Window". Lacking this feature requires the user to either return to the
Financial Center page, or to use the drop -down menus (Inquiry >> Financial
>> Actual vs Budget). Either approach requires the user to re-enter the
account number, essentially starti...Wndws XPsp3: Auto Update ON but system nags all day to Install Upd
I have my Auto Update set for AUTOMATIC to download/install at 3 am daily BUT
I get at least 4-5 messages per day that "Updates have been found formy
computer". Constantly updating/restarting. This is driving me CRAZY. Please
> I have my Auto Update set for AUTOMATIC to download/install at 3 am
> daily BUT I get at least 4-5 messages per day that "Updates have
> been found formy computer". Constantly updating/restarting. This is
> driving me CRAZY. Please help.
We now know the following blanks in the puzzle...
Windows XP ______ ...AD authentication
I would like to ask you what is the minimum packet size for AD (ldap)
authentication between WinXP Pro and Win2003 R2. I am working in the brancj
office and we are connected with main company through VPN - here is located
server farm with DC. Sometimes we have troubles with domain logons. I found
that big packets (more than 1500) can not by delivered to the server. When I
reset ISP router Cisco 1800, authentication is again ok. ISP gived me status,
that his devices wokrs fine and problem is on the our side, because he tested
ping after device restart :( Tommorow I hav...Excel Concatenate formula problem
Im trying what i believe should be a simple formula, i have a list o
500 numbers e.g
25452822 and so on....
I need to insert a "0" infront of all the numbers for which i am usin
the formula =CONCATENATE(0,A1:A500) and this works fine.
My problem being i also need all the numbers to have a space after th
025 452821 and so on....
Message posted from http://www.ExcelForum.com
Easier solutions may exist but this worked for me.
Assuming your concatenated result is in C8.
=CONCATENATE(LEFT(C8,LEN(C8)-3)," ",RIGHT...I need a formula to calculate 2-3 columns but skip a column if it has a zero
I'm building a Golf League spreadsheet and we want to calculate handicaps
starting with the second week (calculates 2 weeks) and then after the 3rd
week calculates every 3 weeks.
Columns B-S are the individual weeks scores for each golfer (golfers listed
by row 4-33), each column (b-s) has a formula which pulls the golfers score
from the input worksheet(weekly input) to this worksheet(scorecard).
Starting with Column V we are trying to have the running handicap for the
year which changes each week.
Column W is the first week handicap =AVERAGE(B4-36)*0.8 (this ones easy)
Column X is the se...sumif formula
is it possible to write a sumif formula to get data from two sheet at the
I want to look for "A4" from Sheet1 & Sheet2 at the same time. the idea here
is if "A4" is in both tabs than give me the sum figure.
Just string 2 SUMIFs together:
Microsoft Excel MVP
"Rohit" <Rohit@discussions.microsoft.com> wrote in message
> is it possible to write a sumi...Auto fill keeps adding 1 digit or 1 cell
When I try to drag a formula or value down or across the
spreadsheet in Excel 2002 (Win XP Professional)it
automatically adds 1 didgit to the value or references
the cell next door to calculate the formula. How can I
make the drag and autofill more accurate?
Try draggin with the right mouse button. When you get to the end of your
range you get a list of fill options.
"Ricardo" <email@example.com> wrote in message
> When I try to drag a formula or value down or across the
> spreadsheet...Unable to set Date Range on UPR_Month_End
I am in Dexterity, and I am opening the form UPR_Month_End and setting the
date range unfortunatly the set start date and end date are being wiped out
before the form makes it to the user. My code worked before the last
service pack from Great Plains, and I have tried many things to get it to
work. Basically what i am doing is on a button click on one of my forms I
am trying to set the date range on the period end payroll reports screen to
the beginning and end of a quarter for convienence because the ability to
run quarter end reports was removed from Great Plains. Below is the code...Display Date from Unbound Field in Form in a Query
Just had an issue that in 10 years of using Access never saw - just wondering
if I just never encountered it or what...
I have a form running a query, the user enters a date. The report needs to
show the date - so the query has a field like this:
report date: [Forms!]![frm_report]![txtReportDate]
I had a problem exporting to Excel - seems the direct placement in the query
led to characters that Excel could not understand. I actually had another
date field from the form that I did a date add on, it worked fine. I
eventaully put the form reference in a Format, the issue was gone.
The...Macro help: Adding Specified Blank Formatted Rows Automatically?
How do I make a macro that will prompt with a dialog box to copy the
rows a certain number of times. For example, if I have 2 rows of data
and I want to be able to specified any number of copies of the 2 rows
blank without the data but maintain the formats (colors, condition,
formulas, code, etc.). I want to add the rows to the existing
worksheet. Also, I would want to this macro to be flexible to maintain
it�s function if I add or delete columns from the chart.
See sample chart
File Attached: http://www.exceltip.com/forum/attachment.php?postid=279064 (question5 sample1.xls)
----------------...Interesting challenge to highlight instances of >10 consecutive days scheduled
This is a multi-part message in MIME format.
In column A (A12:A377) I have this year's dates by day. In a cell in =
another column, let's say cell D1, I want to put in a calculation that =
will present the word "OVER-SCHEDULED" when there is ever a time when =
someone has been scheduled in to work more that 10 consecutive days in a =
row. The calculation must look for the following schedule codes to =
determine a work shift: D,E,N...Handling bill-related dates
(Using MS Money 2007)
I would like to register the following date when managing bills:
1) The emission date
2) The due date
3) The payment date, which can be before or after the due date.
Is it possible?
Thanks a lot
"EMoscosoCam" <EMoscosoCam@discussions.microsoft.com> wrote in message
> Is it possible?
I would like to have all 3 dates registered, but I do not know if MS Money
allows me to do so.
Moreover, If a bill arrives, I would registered the emission date and the
due date. But when...Adding an email account to Outlook Express 6
I have followed the directions provided in adding my account. The email
address I am trying to add is actually a Netscape email account (provided at
work.) I would rather use Outlook for my emails for obvious reasons. Set up
as POP3, no auth req. I am getting an error message when I click send/rec and
when I try to send an email from Outlook. Anyone??
The message could not be sent because one of the recipients was rejected by
the server. The rejected e-mail address was "my email addrss.net'". Subject
'', Account: 'mail.wacoinc.net', Server: 'smtpout...What is the formula to convert a whole column containing date to text?
What is the formula to convert a whole column of date to text?
If I am to do it cell by cell, I need to press F2 then put a --> ' in
front of the date.
Is there a way I can do it with formula? I have tried CONCATENATE to
combine column a which contains ' with date 12/31/03.
Column A Column B
' 12/31/03 =CONCATENATE(A1,B1)
However, the end result I got is as follow.
where A1 stores your date value. Copy this down
I require a formula that will count how many days between two dates.eg
23/05/02 and23/05/03. Using the rcommended formula days360(the two
dates here)gives the answer 1 as in one year.........help meeeee please!
You want the DateDif() function.
It's undocumented, except in XL2k, so Chip Pearson has fully explained it in
his web site:
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------...Re: how get rid of cells with unused formulas
Actually a much older solution is better for suppressing zero values
selectively -- format with a custom format so that the third parameter
is empty which is a zero value. This allows you to be selective.
Format, cells, number
the fomat of custom formatting is
positive numbers; negative numbers; zero; text
you can override positive, negative but those are the defaults.
see the topic "Create a custom number format" in your Excel Help.
David McRitchie, Microsoft MVP - Excel [s...how to make gaps in plotted data when cell has formula
I have a simple data set with a value for each month except June.
I want the chart to reflect a gap for June, not a zero value. Although I
did tools, options, chart, make empty cells plot as gaps, it still plots
the June value as a zero.
In an attempt to get rid of div/o error, I have a formula in the data set
as If (b5=0, "", c5/b5) . What I'm plotting is the quotient c/b.
We have determined that the formula is what is causing the problem.
Interestingly, if I open this same worksheet (as is) in quattro pro, the gap
appears in the chart.
Is there a different way to do th...How to Add New AD user "attribute"?
We want to add a couple of new "attributes" to our AD user accounts. I am
not sure that "attribute" is the correct wording but here is what we want:
Like you have these "attributes" by default for each user
we would like to add these
I am quite certain that this will be a Schema modification but I am just not
sure how to properly do this? Any help is greatly appreciated.
you might want to consider using the custom attributes for these...
"Fred Yarbrough" <firstname.lastname@example.org...Adding user CAL to Action Pack CRM 3.0 SBE
We have CRM 3.0 SBE installed from our Action Pack subscription. We have
need to go beyond the 10 included user licenses and have purchased 2 more SBE
user CALs through Microsoft Open Licensing (along with a 5-pack of 2003 SBS
CALs we needed). The problem is on the eopen website where I get the license
keys for the 2003 SBS CALs, the new CRM user CALs are listed but there is no
license key. I have no idea how to get the key needed to add the licenses we
just purchased to our current CRM installation. I can't even seem to find
anyone to call who even understands the problem. ...Adding interest to an invoice that is past due...how?
I, like many other businesses, have a problem with
customers paying after the terms of the invoice. I would
like to know how to handle adding an interest penaly to
the invoice and then mailing it back out to the customer
when payments are not received by the terms date on the
Does Money 2004 Small Business have a way to do this?
I have been with this product since Money 99 Small
Business, and it does not seem that any significant
features have been added to the Small Business version of
...set first day of the week
how to change the first day of the week (that my boss use a weekly reports)
set datefirst 6 statment, completed succesfully but with no changing of
default setting ( 7 ) ,any help please
...Time / Date on X axis
I'm trying to plot a series (i.e. groundwater elevation)
on the Y axis against the time and date on the X axis.
The time and date are in separate columns. I can't get
the X axis labels to appear correctly. The entire X axis
label appears as a black box. The data series plots
correctly. I can not seem to adjust the data label
interval as with a single X data series plot.
Is your X axis time + date, or time on a given date; I mean, does it go
from midnight to midnight and you have multiple series corresponding to
each day, or does it start at X o'clock on one day...