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...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 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...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
...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...Calculated field options???
Here's my Data:
In my pivot table, 'Country' is an item, and 'Status' is my only data field.
What I really need to show in my data area is two column of data, one for
'Green' and one for 'Blue'. I tried creating two 'Calculated' fields with
the following formulas, but they don't seem to be working:
'CalculatedField1' = IF((STATUS="Green"),1,0)
'CalculatedF...Insert calculated median field in pivottable
Anyone know how to get a median calculation in a pivot table? I've tried
inserting a calculated field but it always sums the calculated field.
Not supported in a pivot
(No private emails please)
"Joel Schaefer" <email@example.com> wrote in message
> Anyone know how to get a median calculation in a pivot table? I've tried
> inserting a calculated field but it always sums the calculated field.
issue us? Essentially I need to be able to calculate two values, one
is addition and the second is multiplication. I am getting some
strange numbers. My code is at the bottom under the ------, here are
crmForm.all.estimatedvalue.DataValue = 10
crmForm.all.new_cfp_estrev_nextyr.DataValue = 10
crmForm.all.new_cfp_estrev_yrtwoplus.DataValue = 10
This should make totalestrev = 30,
Then its getting weird, I am taking the following formula (10/100)*30
= 270? Here 10 is the value selected from the drop down value, I
how can I format several dates such as 04/19/2003, 04/01/2004, etc. int
a yearly average for the employee tenure
Message posted from http://www.ExcelForum.com
right now say I have my yearly figures in i1-i9. The formula I though
would work is
=today()-average(i1:i9), but how would i format this to give me
yearly read out
Message posted from http://www.ExcelForum.com
One way is to use YEARFRAC with a third argument of 1 to get your
tenures in years and fractions of a year and then average the result.
However YEARFRAC does produce some annoying but small errors.
Y...Formula to calculate time
I was wondering if anybody knows of a formula to allow you to do calculations
based on time. In other words, say I want to put a list of songs on a CD and
their durations. Then, I want to add up the durations to get the full time of
the CD, or my specific play list. So for example, using the information below:
Ghostbusters - Ray Parker Jr. --- 5:23 (Just a guess)
Phantom of the Opera Overture --- 3:55 (Another guess)
Instead of 8:78, I'd want to see 9:18
Can this be done? Any help would be greatly appreciated. Thank you!
Have a nice day!
Charting the futu...Time Sheet Function to Calculate
I am having some trouble trying to establish a formula that will give me the
number of hours worked during the day given the start time say 8.30am with
an end time of 5.30pm and say 30 minutes for lunch. For this scenario, total
working hours would be eight and a half hours but I need Excel to display
this result as 8.30 hours (0.30 being the minutes in the half hour) and not
8.50. Can someone suggest what to do?
Typically the layout would be
Column A - Start Time say 8.30am
Column B - Time in minutes spent at lunch say 30 minutes
Column C - End Time say 5.30pm.
Column D - the calculati...calculation formulas
Since today I am facing some peculiar change in my excel files. When I
drag a formula from one cell to another cell, result of the first cell
itself are reflected in the subsequent cells. Then I have to press F9
key so that all cells give proper calculation of the formulas.
Product Price Qty Value
A 2 10 20
B 5 15 20
C 10 20 20
D 4 2 20
E 6 5 20
I did the above table in exel. Cell D2 was the result of
multiplication of B2 & C2. Thats is correct. The I dragged the formula
from D2 to D6. However in this res...Calculator
If your using a calculator other than the clunky one that comes with
Windows, you can have IT open form within Money by editing the Registry.
Browse to HKEY_CURRENT_USER\Software\Microsoft\Money\12.0
Edit the String Value, Calculator to point to the path of your preferred
...How to Create a Discount Calculator based on volume
I am trying to create a cost calculator form, which will automatically
calculate the discounted monthly price for a service based on the
number of units. I want to have a single cell which will calculate the
discount rate based on the number of units.
The discounts are:
if units =<50 price = 10
if units =>51 and <101 price = 9.75
if units =>101 and <201 price = 8.75
if units =>201 and <301 price = 8.00
if units =>301 and <401 price = 7.00
if units =>501 and <501 price = 6.00
if units =>501 price = 5.00
I have tried to create a module in VBA,...calculation of average cost GP 9
GP 9.0 automatically generates adjustments in the General Ledger if an item
was sold or was consumed from inventory and if the cost was then changed.
Does it also post the transaction to the sub ledger?
If it only makes a general journal entry to the GL then you sub ledger will
never match you ledger. Is this correct? How can this be a feature?
Are you telling us that when you perform a transaction that consumes an item,
like an issue transaction, you are changing the cost on the transaction? You
should not do that! In average costing systems, the cost displayed on the
transaction scre...calculating clock times
if i enter "7:00 am in one cell and 5:45 pm in another cell, what formula do
in enter in another cell to caluclate the time?
On Sun, 7 Mar 2010 11:04:01 -0800, gma <firstname.lastname@example.org> wrote:
>if i enter "7:00 am in one cell and 5:45 pm in another cell, what formula do
>in enter in another cell to caluclate the time?
If the first cell is A1 and the other cell is A2, try the following
formula in a third cell:
Format the third cell to display the time difference the way you like.
Hope this helps / Lars-�ke
do you mean subtract or add??
...Calculate a biweekly date
Is there a way to use a formula to calculate a biweekly pay day? For
example, I want a spreadsheet that automatically puts the date for every
other Wednesday throughout the year??
Automatically how? In what way, what would you do to trigger this date
"TimT" <TimT@discussions.microsoft.com> wrote in message
> Is there a way to use a formula to calculate a biweekly pay day? For
> example, I want a spreadsheet that automatically puts the date for every
> other Wednesday th...Excel Calculator..
How would I go about this and is it doable?
I want to make a calculator that will determine the number of stamps needed
to get postage needed.
Column A will contain the header "Stamp Value". Below it will be every stamp
denomination currently available, ie: .42, .17, .27, .01, .03, etc.I'll
input these and change them as necessary.
Column B will have check boxes that you can check off what stamps you have..
for example in our office I have $1.00 stamps, .42 cents, .27 cents, and .17
One of the cells on the sheet you will input how much postage you need..
f...automated employee tenure summary using Customized Charts with VBA
:confused: hi, can you help on my queries?
i want to use a single excel file as my database (for employee tenure
summary)....the first workheet will contain the interface(built using
VB objects) the second will contain the database and the third one will
contain the charts...
1. how can i update my database without the cells being overwritten by
the new record?
2. how can i make my chart be updated automatically according to this
categories.... name, length of tenure (in months then in years), length
of training (in months) and the time of resignation, by just inputting
the current date......Two Calculations in one cell?
Is it possible to have 2 separate calculations in one cell?
I have a summary Table on one Sheet which gets its values from two other
D E F G H
2000/1 2001/2 2002/3 2003/4 2004/5
20 Bonus: Area 15 11 10 6
21 Bonus: National 28 29 63 22 39(5)
22 Voucher : Area 22 52 84 54 52(7)
23 Voucher : National 36 7 25 21 17(3)
24 Team ...Calculate AGE
i need help to calculate age by using dob.what kind of field do i need for
the dob and what kind of format?
DOB should be a date field.
Age (in years) is calculated as
DateDiff("yyyy", [DOB], Date) - _
IIf(Format([DOB], "mmdd") < Format(Date, "mmdd"), 1, 0)
DateDiff calculates how many "year crossings" occur between the two dates:
it'll say that there's 1 year between 31 Dec of one year and 1 Jan of the
next year, despite the fact that it's really only 1 day. That's why you
subtract 1 from the calculation if the ...how to calculate exchange rate?
Please I need a formulea to calculate Country exchange rate?
Question is a bit vague... If you just want a formula to say convert $10
(In A1) to �GBP (In B1) at a rate of 1.8 �/$ then in Cell B1 enter
You can put the exchange rate in say C1 and always refer to that, so it's
easy to change
or is you have a series of currencies with say currency codes in a table
with their exchange rates then you should consider looking at VLOOKUP in
If you need more help. post back with more info
Microsoft MVP - Excel
nic...VBA Calculation with Variables 03-26-10
Hello: I'm trying to modify a program I wrote with some help a number of
years ago and find that I have fallen behind in programming thought. The
program currently scans each row (representing a person) and places up to the
last eight >0 values into an array which is then sorted low to high numbers.
In that version the 4 lowest values were summed and an average returned .
The revision is to place up to the last ten >0 values into the array and
sort low to high. This is where the change takes place in that now I want to
calculate an average if there are anywhere ...Tenure Date Formula
I am trying to figure out a formula using today date - start date=
years.months in service. Can someone help me.
adams77's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23695
View this thread: http://www.excelforum.com/showthread.php?threadid=567485
Microsoft MVP - Excel
"adams77" <email@example.com> wrote in message