Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
Hello Excel Problem Gurus,
First of all, let me thank you in advance. I find it exemplary that
you all can devote time to helping others who are having issues with
their work. Hopefully one day I can be at a mentor level, and help
Hope you can help! I have an issue where I don't know how to write the
formula that I need without going over on the nesting. The current
formula that I have is as follows:
Data",IF(V7="Yes",&qu...How do I create a sample in Excel?
I am trying to create a sample, needing every 20th record out of around 3000
You need a VBA procedure.
Dim RowNdx As Long
Dim DestRng As Range
Set DestRng = Worksheets("Sheet2").Range("A1")
For RowNdx = 1 To 3000 Step 20
Set DestRng = DestRng(2, 1)
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Mary" <Mary@discussions.microsoft.com> wrote in message
news:ADE0AD7F-B459-41AE-8B2...Excel 97 Win XP calc problem?
I have a machine running office 97 and Win XP.
I have seen posts stating it runs fine, but I don't know how man
people use spreadsheets that require a hard calculation:
Excel will not force a calculation. i.e. ctrl-alt-f9 does not cause
full workbook calculation as required.
Meaning cells do not update and it doesn't calculate unless you clic
in the cell to edit and hit enter.
neither does the "Calc Now" button.
Auto or manual calculation mode has no effect.
Anybody else have this problem
Message posted from http://www.ExcelForum.com
Make sure that both the SR1 a...TempVars unusable in field default value
I'm trying to use a temporary variable to keep track of which CSR is
I have a macro which prompts user for ID code, which is stored in the temp
On a form control default value property, I can use the expression
[TempVars]![TempUser], which will populate that user's ID code into the
However, I cannot use that same expression in the tables field default value
property. If I try, when I save the changes to the table, I get the error
message "Could not find the field 'TempVars]![TempUser'. "
Any ideas why I ca...rounding up values
Has anyone done round up of values to the nearest dollar.For example I want to give a 10% of the price to my customers but if the result is other than .00 then I wanted to round up to the nearest dollar amount.My calculation using sql has been price * percent and then subtract the value from the price, then what do I need to do to roundit up??Thanks for your suggestion.Also I have a problem with my customers that I am extracting and the query does return all the values from 2004 and 2006 that are equal except for the price I have given them, how do I get only the latest ones in 2006 and not th...Date display in Excel
Format column of cells as Date, display as mm/dd/yy. Date
entered into cell, shows up correctly in the text entry
field at the top of the screen, but the data on the
worksheet displays as "33747", or similar number. Only
happening on one workbook.
Try tools|options|View tab|uncheck Formulas.
> Format column of cells as Date, display as mm/dd/yy. Date
> entered into cell, shows up correctly in the text entry
> field at the top of the screen, but the data on the
> worksheet displays as "33747", or similar number. Only
> happening on one...Cannot open Excel attachment from e-mail when Excel is already ope
This is driving me crazy. If I already have Excel open (with or with out a
spreadsheet open) I cannot open an Excel spreadsheet attached to an e-mail.
If I close Excel and retry it will open Excel and the spreadsheet.
Any ideas? I hate having to close all my open spreadsheets when I want to
open a spreadsheet that's been e-mailed to me!
One of these usually works with a similar problem starting workbooks by double
clicking them in Windows Explorer. Maybe one will work for you and your email
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close E...Excel and some disappeared sheets
Anybody has the same or similar experiences :
- I worked with excel file / closed as usually
- new day opened and unfortunatelly some very important sheets
disappeared / why ? Don=B4t know
- I had about 7-9 sheets just now only 3 ones are there but not so
important as another ones
- the file has original size / I quickly looked into file by normal
text editor only for reading
and all relevant data are there, however if I open file by Excel, NO
original sheets or data
- this file is VERY IMPORTANT for me
- why happened ? Don=B4t know since I ask anybody for help
Thanks in advan...office 2000 [excel] cannot open previously OK file. Help
When trying to open a Microsoft Excel Work Sheet that I had accessed modified
and saved to only yesterday [Office 2000] a window pops up with:
"name.xls cannot be accessed. The file may be resd-only, or you may be
trying toaccess a read only location. Or, the server the document is stored
on may not be responding."
Older files stored on the same mediums ;HD, Flash memory or 3.5in. diskette
are accessed with no problem.
This is on a network drive?
...Starting an Office Program (word, excel) in Outlook to send email
I'm taking an Outlook 2002 class. The latest assignment
requires I open a Microsoft app in Outlook to send an
email. Troubleshooting so far: Have tried to install some
addl features from CD, restarted the pc (O/S WINXP) but
still get error "Cannot complete action". Get no reason
why Outlook cannot perform this action and the HELP
hasn't only points me to inserting an object or some
variation thereof. My Outlook is configured to use with
Steps (abbreviated) given in textbook to perform:
New mail using Microsoft Office
Also tried to perform from Wo...cell contents revert to 0 when i click on the next cell
I put a number into a cell click on the next cell and the first cell reverts
to 0. If I format to number with 2 decimal places it will be ok but when I
try to take out decimal places it goes back to zero,
You haven't said what number you are trying to put into the cell, but I
suspect that the number is less than 0.5.
A quick test shows that if you set the cell to no decimal places then enter
a number less than 0.5 it is displayed 'rounded down' so it will show as
zero, if it's 0.5 or above it displays as 1.
If you need to put numbers less than 0.5 into youe c...is there a way to program my Excel file to do a loop?
If I want B10 to B17 all follow the change of the same number(copy cell),
let's say I put it in A1,
and C10 follows the change of A2(copy cell), and C11 follows the change of
A3(copy cell), and C12 follows the change of A4(copy cell),
then I have 4 variables in my calculations: A1, A2, A3, A4.
I want to loop each of the variables in a different set,
then I hope the whole worksheet will be able to refresh following the change
of A1, A2, A3, A4,
and then I want to find the very set of A1, A2, A3, A4 that gives the
smallest value of D10,
how do I program the whole procedure...Excel 2007 PC damages Mac Excel 2008 Files
Operating System: Mac OS X 10.4 (Tiger)
When I open a Mac Excel 2008 file on Excel 2007 and I can work with the file, however when the file is returned to the Mac, it no longer works correctly, leading to a crash as soon as I try to save or eventually it might change the file to look like a bunch of letters and characters. Here is the error report: <br><br>Microsoft Error Reporting log version: 2.0 <br><br>Error Signature: <br>
Exception: EXC_BAD_ACCESS <br>
Date/Time: 2010-01-15 17:05:56 -0600 <br>
Application N...Excel. I am having a problem with hidden text
As I type text in some cells, it does not always dispaly if it exceeds the
cell length. I wish to keep the cell lenghts for the entire document, but do
wish for teh text in that particular row to be displayed.
How about if you select that cell, then
format|cells|alignment tab|check wrap text
And with that row selected
> As I type text in some cells, it does not always dispaly if it exceeds the
> cell length. I wish to keep the cell lenghts for the entire document, but do
> wish for teh text in that particular row to be displayed.
Da...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...Excel Grid Lines in Outlook Preview Pane
Is there any way to send a spreadsheet to a mail recipient in the body
of the message and not have the grid lines show up in the Outlook
preview pane when the recipient views the e-mail? If you open the
e-mail in Outlook, the grid lines disappear, but in the preview pane
they are there.
Using Excel and Outlook 2003.
Uzytkownik "Kimberly" <Blackrose73@gmail.com> napisal w wiadomosci
> Is there any way to send a spreadsheet to a mail recipient in the body
> of the message and not have the grid lines show up ...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...Multivalue with Null value SSRS 2005
I have a query to populate a multivalue parameter:
SELECT distinct cast(AGRPYear.value as varchar(4)) + AGRPMonth.value
FROM TPROJECT AS TPROJECT
One of the values that is returned from this query is NULL. However, when I
run the report, the NULL value does not show in the dropdown. I've also
"select NULL as 'ReportDate' union" to the above query and the null value
still doesn't show.
As a result some of the records in my database have a null value for this
field, they will never show up on my report. Any id...Like a pivot table
Hello every body
I'm first time requesting in this group, so I opologize in advance for any
mistakes or something annoying
I repeat what I have sent before 10 min because I see it unclear when it
goes to news group
If any one can help me
I'm working with data which most of it comes like a table with feilds as
columns and records as rows. I want it to be as many rows with each feild
what is exist
name age Joining Date Tele
John 20 Jun-90 4321251
Iqbal 30 Jul-95 6583752
George 40 Sep-85 7843125
What I wa...Excel error 1706
Whenever I try to start excel on my computer it displays
an error message and it shuts itself down, any other
program from the office pack works properly, except for
the one I mentioned. I reinstalled it and it does the
exact same thing.
Thanks in advance.
...when opening an excel file, 2 files open (one is book1)?
When I click on an excel file, 2 excel documents open up. One document is
called Book1 and the other document is the actual document that I want to
open. How do I stop this from happening?
To prevent Book1 from opening you can append /e to your shortcut for opening
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e
Alternative to the above............
Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.
If using WinXP OS you would scroll down to...Mail merge from excel
I am trying to merge a list of names from excel into publisher. When using
the mail merge wizard it wont let me load the names all it says is f1 and f2.
what am I doing wrong? any help is greatly appreciated.
...Excel Jululian 04-24-10
i have a lists of names and i want to separate each in a colum like
You Light Up My Life197711
You Light Up My Life (in one colum "A")
1977 (in one colum "B")
1 (in one colum "C")
1 (in one colum "E")
First many thanks on your reply
the text are different in length
"מיכאל (מיקי) אבידן" wrote:
> 'Data' > 'Text to Columns' > 'Next' > mark/un-mark the vertical separators as
> shown in the picture > 'Finish'
>...Opening Excel email attachments
When downloading excel files AOL says cannot find
suitable program.I then go online to find Excel but only
PC is XP version with Works Suite 2002.
A fe months back my dear wife was downloading Excel an
got board with waiting and shut down the PC!
there's no legal way to download Excel!!
You have to buy< an Excel version and install it on your
PC (or try to open the file with MS Works - but live with
the restricted functionality)
>When downloading excel files AOL says cannot find
>suitable progra...Textbox fomatting value based on another textbox
I have two text boxes on a form. One is a value that can be changed by the
user. The second is the value 1 - textbox1. I need everthing to be in %.
For example, in textbox1 the user could type 75 and it would automatically
be recognized as 75% and textbox2's value would calculate to be 25%.
Everytime I try textbox1's value is = to say 7500%. Any help is
Maybe something like:
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim TB1Val As Double
If IsNumeric(.Value) Then