Clear data without deleting formulas
We use several spreadsheets on a monthly basis, so every
month must delete the data that was input for the prior
month to put in the new data. However, we also need to be
careful not to delete any of the formulas while we're at
What is the best way to clear out data without deleting
the formulas too? Deleting contents row by row (or column
by column) takes too long.
Select your range of cells that can be cleared. Be careful not to select too
much (but you can eliminate formulas later).
Now with that range selected:
hit the delete...IF Stmt. to calculate cumulative commissions
I am trying to write an IF statement that will do the following:
It calculates a commission amount based on 3 level of Sales:
If Sales is < = $1,500, calculate 0.0025*1500
If Sales is < = $3,000, calculate 0.0045*3000
If Sales is > $3,000, calculate 0.0050* cell reference...
Now, this may look easy enough..here's the trick that needs to happen
Say, sales is $5,500..the commission calculated should be cumulative i.e.
0.0025 * 1500, + .0045*3,000 + .0050*(remainder amount)
What would be a clean way of doing this? I will appreciate any help. Thanks.
Shams...Transaction keeps downloading even after accepted multiple times
I have a checking account which downloads automatically / updates
automatically when I start Microsoft. There is one transaction from
11/12/2007 that downloads every time, even though I have accepted it or
matched it with a transaction and it still keeps downloading.
What do I do?
I called the bank and they say it is a Microsoft problem.
In microsoft.public.money, Connie wrote:
>I have a checking account which downloads automatically / updates
>automatically when I start Microsoft. There is one transaction from
>11/12/2007 that downloads every time, even tho...Excel formulas 01-06-10
I have a worksheet that we would like to use to calculate price + labor for
work. The price formula has me stumped. I would like to be able to put in the
price in one box and have the formula determine the amount at which to
multiply it by.
Price = 20.00 then the formula would determine how many to multiply it by
(3.25) from the range given below.
Range is 0-2.00 *4
I have the labor formula and then the total is a sum formula. Please help...Is there Formula to Tab to certain cells
Is there a formula to tab through certain cells? I have a form with about 15
cells that I would like to access easily through the tab key....is there any
way to do that?
One way to explicitly control the exact "next cell of focus" selection, is
to select the cells in the desired order of travel, and then preserve this
ordered movement by creating a named range.
This old post describes the steps that can be taken to create such a "named
Please keep all correspondence within ...need help with formula for a newbie excel guy
this might be a stupid question to all of you excel experts out ther
but please help me.
cell c14 = 0
cell d14 = 5
in order to get an N/A in the equation cell, here is the formula that
is it possible to get a formula to have N/A if either cell is "0"???
please help, thank you
ben803's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3513
View this thread: http://www.excelforum.com/showthread.php?threadid=54896
Instead of ...Customer Stats
I have a spreadsheet that logs the time/name/enquiry/etc of Customers.
I need it to count the number of callers within each hourly period ie
9:00, 9:10, 9:20, 9:25 would be 4 callers etc, for statistical
analysis. I need to send this info to a graph showing volume of callers
over the day.
I am at my wits end - i am sure it is sooo simple. :confused:
Message posted from http://www.ExcelForum.com/
A pivot table may be the answer. Use the time of day as
the row field, and then group all of the calls into hourly
Hope this helps
>-----Original M...Show formula result in another sheet
sheet1 A:A contains a formula with some cells returning a value
sheet2 A:A references sheet1 A:A with a simple formula:
above formula filled down in sheet2 A:A
the problem is it is not showing the results from sheet1
anyone know why that should be?
Sorry false alarm, I had calculation set to manual. Results are coming back
as they should. Red faces all round.
> sheet1 A:A contains a formula with some cells returning a value
> sheet2 A:A references sheet1 A:A with a simple formula:
> ...Margin Calculation
I am looking to create a formula where when the total cost of goods in
known, I can input a desired margin and it will give me the sell.
So if margin= (sell-cost)/sell*100
Message posted from http://www.ExcelForum.com/
Assuming cost in A1, sell in B1:
In article <firstname.lastname@example.org>,
kbulm <<email@example.com>> wrote:
> I am looking to create a formula where when the total cost of goods in
> known, I can input a desired margin and it will give me the sell.
> So if margin= (sell...override GMT time on all outbound emails
It appears that outbound emails sent by CRM (delivered through the SMTP
server) ignore the timezone settings on the CRM server and always set the
message with an origination time based on GMT.
How can this be changed? Emails look very unprofessional when the "Sent"
time seems to be many hours different from the actual local time.
It makes it look like either the CRM user is working at strange hours or is
taking forever to reply to a client.
...FORMULA HELP! Find all values in column at random rows and perform calcutlation.
1000 Total of formula here.
I don't know what row a % number will show up on col A but it is before row
1000. I would like row 1000 under column A to have a formula that says
look for any row in column A and if you find a number, add 1 to that number
and then find the next one and add 1 to that number and then multiply those
two together and then find the next one add 1 then multiply to the last
Bascially, A100 would have the formula (1+A3)*(1+A6)*(1+A9)*(1+A12)...e...Freight Rate Calculator
When entering a sales order in Great Plains, we would like
a tool to calculate the freight based on zip, dimensions
and weight and write that amount into Great Plains.
Any third party product out there that can do this?
Have you looked at Vship from Vsync? or Starship?
Are you shipping via UPS, Fedex or over the road carrier?
Business Microvar, Inc.
>When entering a sales order in Great Plains, we would
>a tool to calculate the freight based on zip, dimensions
>and weight and write that amount into Great Plains.
>Any third...Need help with a simple Time calculation
I'm a little new in Excel, I need some help
with at sheet, that are able to calculate time
something like this:
text1 3:30 (3 min 30 sec)
text2 2:10 3:40 (result of text1 and test2)
text3 1:40 8:20 (result of text1, 2 and 3)
Thanks in advance
if the fields have times in them as they appear, just add them like any
other cells and format as mm:ss or hh:mm:ss
"Bjarne Hansen" <firstname.lastname@example.org> wrote in message
> ...Date Formulas #3
How can I make a cell correct the year of a date
not really sure what you're after here
if you have
and you want to display just
then right mouse click on the cell and choose format cells / on the numbers
tab, choose custom and then type
in the white line and and click OK.
however, this just displays the date showing only the year, if you want to
extract the year only to another cell you can use
where A1 contains the date
if you're after something else, please type a few examples of the data you
have and what you want to see.
JulieD...How to copy & paste a worksheet but change 1 bit of the formula?
I want to copy a worksheet names WK 15 that has several formulas in linking
to WK 15 of other sheets, then paste it to create another workbook but
changing all the formulas to WK16 and not WK15 but keeping all of the other
data within the pasted formula the same.
EG: SUM('Y:\AREA\PARADE\[WK 16.xls]Sheet1'!D$6) and various similar formula
to be copied and paste onto a new workbook but change [WK16.xls] to
[WK17.xls] only within all of the formula so I do not have to keep manually
changing each cells formula myself.
You can create a copy of the worksheet by holding the C...How is Return for Period calculated?
I am using Money 2003 and I did a Performance by
Investment Account report for 2004. For most of stocks the
Return for Period column is the Realized Gain/Loss + the
Gain/Loss of your current holdings. However for some
stocks the numbers don't seem to add up. For instance the
realized gain is $400, gain of what I currently have
invested is $500, and the return is reported as about
$100. Could someone explain to me how this is calculated
or if it's a bug.
I have a datasheet with time values that are in minutes:seconds format and I need to graph them in some way. However, the only way i am finding to graph them is by manually rounding the number to just minutes. Manually rounding the numbers will not work in the long run because I need to have an automated process and no formula will work with my numbers.
here are some of my numbers in (minutes:seconds)
That is the way they are given to me and I would like to use them in that format however I can't figured out how to have those...Please Help Running a Macro from a formula
Is there a way to cause a macro to run from a formula?
As an example:
GoToNeg and GoToPos are macros which will manipulate B1
Thanks in advance!
If they really are macros that alter things on a workbook, you can't do it.
If they are functions that return a value, then that is possible.
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Vic" <email@example.com> wrote in message
news:firstname.lastname@example.org...Resolving Polynomial Trendline Formula for Chart
How would the following Chart equation be resolved in Excel:
y = 147832x2 - 150195x + 2E+07
Please explain what you mean by "be resolved"
To get the trendline values into cells see
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"soccerkatie" <email@example.com> wrote in message
> How would the following Chart equation be resolved in Excel:
> y = 147832...Fairly intricate array formula question.
I have the following array formula, works correctly for me in cases where
both input values are nonblank, but i don't get the result i need if one or
the other is blank. Here's the formula:
[Actually if you are interested, it is the crossproduct term, the numerator
of the formula given the help file for the Excel SLOPE function].
What i want the formula to do is skip any row in which a value in range
A11:A61 OR B11:B61 is blank, and continue to return the crossproduct sum for
the rest of the rows...if formula #5
i have data in sheet 1 and if the column AG has agent code 1,2,3,4, and so on
i have creatred different sheets for the agents i want when the data is
inputed in sheet 1 and when column AG is updated the information should be
copied to respective sheet.
-Navigate to the cell in the sheet that needs to update automatically
-Press the equals (=) key
-Navigate to and click on the cell that contains the value required
"nishkrish" <firstname.lastname@example.org> wrote in message
WHERE CAN I GET A LIST OF ALL FORMULAS MICROSOFT EXCEL USES?
Excel's help for worksheet functions?
Take a look at Peter Nonely's workbook that describes lots of functions:
If Peter's site isn't working, but Ron deBruin has a copy at:
Norman Harker has his version at Debra Dalgleish's site:
> WHERE CAN I GET A LIST OF ALL FORMULAS MICROSOFT EXCEL USES?
...Control formula calculation
I have created a "form" where a user enters 2 separate numbers. I wan
each of these numbers to input to a running total and the total t
subtract from another number... this is what I have come up wit
(understand it is a circular ref ..)
User input 2 User input 2
Prior input 0Prior input 0
Total input 2
Message posted from http://www.ExcelForum.com
...Formula help please #8
Can you help?
in Worksheet 'Stats' cell H8 I want the value of cell R8 in worksheet 'Log'
to be shown, but if the value in cell R8 in worksheet 'Log' is zero (0), then
I want the cell H8 in 'Stats' to be blank.
Just to complicate things (if it does), there is already a formula in cell
R8 of the 'Log' worksheet, which is
Go easy as I'm the novice
Cheers for help
Microsoft MVP - Excel
"Anthony" <Anthony@discussions.microso...template or formula for start time -finish time -total hours ple
please could I have a formula or function to enter start time-end time and
show total hours/mins for excel
with start time in A1 and end in B1 using excel time format hh:mm:ss
the first 2 formulas work if start is before and end is after midnight
"cc" <email@example.com> wrote in message
> please could I have a formula or function to enter start time-end time and
> show total hours/mins for excel