Calculating Taxes and Making calculations
Kindly plz tell me how do i go about making some small calculations
based on my existing data such as how to compute taxes and do other
calculations based on some quantitative data.
where exactly do i make modifications on my application???
Kindly help me out.
example might be a dropdown which has shipping options ie ups, fedex etc.
When you choose one it takes the weight of your package (whcih you enter)
then calculates a shipping cost.
search the archives of this group at groups.google.com and ...Excel - PDF
Is it possible to re-convert an Excel file which has been converted to a PDF
back to Excel ?
> Is it possible to re-convert an Excel file which has been converted to a PDF
> back to Excel ?
No easy way if the spreadsheet has become a bitmap image. But OCR of a
printed spreadsheet is a possible solution. You might wind up with a
Word table that you can import into Excel.
You can turn a PDF file into an Excel file, you will NOT have the
original Excel formulas macros etc. Only Text and or numbers.
> Is it possible to re-convert...Procedure to calculate distance using latitude/longitude
Does anyone know of a vba procedure for access that will calculate
straightline distance using latitude and logitude for 2 points?
> Does anyone know of a vba procedure for access that will calculate
> straightline distance using latitude and logitude for 2 points?
James A. Fortune
...How to calculate age of a person?
I'm struggling to figure this one out. I have a date column and I'd like to
be able to calculate the age without doing it in my head.
I've tried to do this but am struggling.
Any help will greatly appreciated.
Visit www.cpearson.com and search for DATEDIFF
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Grd" <Grd@discussions.microsoft.com> wrote in message
> I'm struggling to figure this one out. I have...entering data in excel invoices
...Excel text corrupting problem
Has anyone seen anythink like what is happening in the Excel
screenshot below ..
The text is corrupting in cells. Its just happening on one PC and in
most excel documents on that PC. It seems to happen a lot when cutting
and pasting. So far, I've installed all office and windows updates,
removed the anti virus software to test. Installed all graphics
PC spec is XP Pro, Celeron 3.2GHz, 2GB RAM. Office 2003
Any help much appreciated.
I believe that the display in XL is more through the Printer Driver than XL
itself. T...EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge
I am trying to calculate monthly INTEREST ONLY payment on a short term
bridge/swing loan. Assuming an interest rate of 2.75%, paid monthly, Also
assuming it will be required for a 3-6 month period, amount approx $500,000.
Just switched to Excel 2007 but don't seem to be able to calculate using the
formula builder. Not sure if it is compounded daily or monthly.
You might want to check out the IPMT function. From the XL help file:
Rate is the interest rate per period.
Per is the period for which you want to find the interest and must...Excel Crashes Killing Me
Excel 2004, SP 11.2.3
PowerBook G4, 2 GB RAM, OS X 10.3.9
I've been working on a complex Excel financial model for a month now. I was
putting the final touches on the whole thing this afternoon when it suddenly
crashed. Previous crashes (many) left the model in a stable state and
recoverable. The model has about 400 names ranges and many macros. It
generally has been running stably.
Unfortunately, that's not the case tonight.
I save sequential backups frequently by shutting down Excel, duplicating the
file in the Finder and naming the backup file with a numerical sequence
number. I&...multiuser access to excel files
Is there a way to allow for multiple users to access an
excel workbook simultaneously if it is stored on a network
"Ric Deters" <email@example.com> skrev i en meddelelse
> Is there a way to allow for multiple users to access an
> excel workbook simultaneously if it is stored on a network
Look in the Functions menu. Third item from the top (using a
danish version so I don't know the english name for it)
/\ preben nielsen
tools/share workbook, and a check box. how nea...Due Date Calculated
I need assistance on an expression that allows for the due date of recurring
training to be one year from date completed. Details are as follows:
I have a form named [frmTRNComplete] based on table named [tblTRNComplete]
Form controls are: TRNID (combo box), DateComp (Text Box) , DateNext (text
box), Reccuring (check box)
I would like the DateNext to be 1 year from DateComp if Reccuring is true
and Date next to be blank if Reccuring is false.
I'll assume that you want to use the form to calculate the DateNext, and
that you are not trying to s...Number not showing correctly
Hi, I had tried to enter a 12digit number in a worksheet but after entering
it its not showing the coorrect number.Eg Iam trying to enter 857268578633 in
the work sheet but after entering its showing 8.57269e+11 Why its happened
Like this can you please explain me
the format of the cell is probably 'General' instead of number. When you
select number you can select the number of decimal places and/or the comma
and negative number format if you like. If it then shows up as ###### or
still has the scientific format appearance, you can widen the column.
...Excel Formula #13
I have a spreadsheet to log a persons manhours performed
for the month. 31 columns with a totals column to follow
the last day of the month.
We are a military organization and there are a number of
different statuses that a guy could be in on a given day.
If, on the 5th, the guy works a drill I want to record it
as a "U" so I know his status for the day. I want the
totals column to read that as 8 hrs worked. How can I get
my totals column to recognize an alpha character as a
Assuming alpha characters are recorded in row 1, try:
=SUMPRODUCT((A1:AE1="U&qu...how to calculate outliers
Google is your friend:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"ismhs" <firstname.lastname@example.org> wrote in message
...CSV /Excel File disabled after opening from a network.
I just seems that when i open a csv or excel file from
network or from my mail attachment , the file opens ia
small window and i am unable to maximize it. only i can
close or minimize it.
I have WinXP SP2 installed,also i have run all windows
updates but the problem persists.!!!
with WinXP SP1 there is no problem with such kind of file.
any body have any solutions for this problem...
...New! Consecutive Numbering Tutorial for Publisher 2002/2003
Microsoft Publisher MVP
...converting .wdb files to excel
I need to convert .wdb files to excel files, however, I no longer have
access to microsoft works. Any suggestions?
Message posted via http://www.accessmonster.com
...see multiple tabs at once in excel
Excel should provide the ability to see multiple worksheets (tabs) at once.
I am currently using Excel 2003.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=c56ece01-0850-4900-9659-c6b79575a992&dg=mic...Hyperlinking Excel to PPT address changes
Hi Folks! I am inserting a hyperlink in PPT 07 to an Excel file. I am
creating the hyperlink address to be in the following format for Excel:
Filename.xls#’worksheetname’!A1. I of course am using my own titles and cell
referencing. However, when I create this address in the link, save the PPT
file, close it, and reopen it, the address in the hyperlink address is
changed to just Filename.xls and leaves off the worksheet and cell locations
as well. The hyperlink address will not retain that info for some reason. Has
anyone ever seen this? I am using PPT and Excel 07 with SP 2. Than...group of numbers
How can I make a bunch of numbers being recognized as a group?
I've got the following numbers: 1, 2, 3, 4, 5 and 6.
I want them to be considered as a group.
How can I achieve it?
Thank you for your attention
Message posted from http://www.ExcelForum.com/
You can name the range of cells that contain the numbers. There are
If that's not what you're trying to do, perhaps you could give a bit
PeaceMaker < wrote:
> How can I make a bunch of numbers being recognized as a group?
> I&...MRP Excel Spread sheet
I am looking to download an excel spreadsheet mrp production scheduling
system / format. Can anybody help me.
You try the following site. I have no idea whether it will do what you want
so you can only try it.
If not what you want then try googling the following.
excel mrp production scheduling system
> I am looking to download an excel spreadsheet mrp production scheduling
> system / format. Can anybody help me.
&...Keeping Excell document 'on top'
I have an Excell doc that I input data to from web pages.
I was wondering if there was a way of keeping the
document 'on top'(reduced so that it takes up only a part
of the screen) so that I can input the data without losing
sight of the web page and move around on the web page
without losing sight of the excell doc. Since this may be
a windows query (I'm using W98SE and IE6.0), I've also
posted there. Any suggestions very gratefully received.
There are some third party tweaks for Windows that allow windows to be kept
on top, but I've found that they ca...How to get the digit number of a LONGLONG data?
How to get the digit number of a LONGLONG data?
for example:LONGLONG aaa=123; then the digit number is 3;
LONGLONG aaa=5678; then the digit number is 4;
Another way is:
int digits = 0;
LONGLONG number = aaa;
while (number > 0)
number /= 10;
>How to get the digit number of a LONGLONG data?
>for example:LONGLONG aaa=123; then the digit number is 3;
> LONGLONG aaa=5678; then the digit number is
As long as the number isn't negative.
"Geo" <ckarakiro@hotm...restrict view of certain cells in excel
I am trying to restrict access to some users in excel. I am trying to make
it so those that do not have the password can view the sheet "read only" but
cannot view certain cells. Those that do have the password can view all
Perhaps save as 2 Workspaces?
"Firemann25" <Firemann25@discussions.microsoft.com> wrote in message
>I am trying to restrict access to some users in excel. I am tryi...transaction number #2
while generating detailed sales report in mrms 1.3 we select transaction
number to view journal of that particular bill,we find correct details in
But when we see in detailed sales report , we find items which are not a
part of that journal displayed under transaction #.
Is there query any problem in detailed sales report query in qrp reports.
Have you tried to reindex the database? It's in the RMS Administrator under
the database menu.
Are you having any other issues with the software?
NuRol Point of Sale
I am new to Word 2007 and am looking for a little be of help. hopefully
someone knows the answer.
I am creating a document with various headings. Having set-up my styles I
have now encoutered a problem. I have various sections and the numbering is
ok for Section A, however, when I reach Section B although the main heading
is ok "2 SECTION B" (the numbering following from the main heading of
SECTION A), the main body numbering follows of from Section A and does not
restart. See example below
At the present the document looks like this:
1 SECTION ...