If Then Else??
Cat Indic Apple Banana Coconut Durian
Ripe (R) 10 30 50 70
Unripe (U) 60 40 20 10
Seeded (SD) 70 0 0 80
Seedless(SL) 0 70 70 0
If I have a 1 column for either Fruits (Apple, Banana, Coconut or Durian)and another on Indicators (R, U, SD, SL), at the row that I have maybe listing Apple & Unripe, I want to extract the quantity (60), how do I go about with the If Then Else function?
Am Mon, 19 Mar 2012 07:11:36 GMT schrieb khoo nora:
> Cat Indic Apple Banana Coconut Durian
> Ripe (R) 10 30 50 70
> Unripe (U) 60 40 20 10
> Seeded (SD) 70 0 0 80
> Seedless(SL) 0 70 70 0
...ASP.NET 2.0: problem using xmlDataSource and GridView...
I am having trouble using XML in an ASP.NET 2.0 webform. Using ASP.NET 2.0
beta 2, I have created a blank web page in a C# website. I have added an
XML file (soData.xml), structured as follows:
<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
<descrip>10.0 GB EIDE Ultra DMA 9.0ms Hard Disk Drive</descrip>
<qty...Quicken to Money #2
When I convert from QUICKEN to MONEY 2004 does that
convert my register too?
Yes - it doesn't convert Household Inventory though.
NB Money is always one "year" behind Quicken, so M2004 will only convert
Q2003 or earlier.
Microsoft MVP - Money
For UK tips & fixes see
For wishes or suggestions see
or for UK wishes email to firstname.lastname@example.org.
"Walter Finney" <email@example.com> wrote in message
news:daff01c43b4d$c67...Crop Marks #2
I'm printing admittance tickets 5 rows X 2 columns per page. 4.5x 2.2 page
size. Using the business card template. I have used advanced settngs to
request crop mark but none are printing.
Can anyone offer a suggestion, please.
Thanks for your help.
You will not get crop marks if your publication fits the page. The only work
around would be to use a lesser amount of tickets per page.
Mary Sauer MSFT MVP
"Lee Hunter" <LeeHunter@discussions.microsoft.com> wrote in message
In process of searching thru files on my PC I found two archive.pst files :
1- archive.pst 1.2 GB (Todays file date)
2- archive.pst.2 1.5 GB (older file date)
Is it safe to delete the archive.pst.2 file?
Rename it so it has only the pst extension. Then look what's inside by
opening it in Outlook through File-> Open-> Outlook Data File...
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Steve Klenner" <steve_klenne...Desktop Alert #2
Any way to configure Desktop Alert so that it displays an alert when mail is
received and routed (via rules wizard) to another folder?
I have many sub-folders in my inbox for specific people, and rules to have
those messages moved upon receipt to the appropriate folder. But Dekstop
Alert does not show when these people send me email - only when email is
received and delivered to the Inbox.
It can be set as an Action in the rule
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Create an Office XP CD slipstreamed with...Outlook 2002 e-mail #2
Incoming e-mails are being automatically deleted by
Outlook 2002, what can I do to stop this?
Are you sure or do you have a view applied to the in-box?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
After searching google.groups.com and finding no answer, Aerozona asked:
| Incoming e-mails are being automatically deleted by
| Outlook 2002, what can I do to stop this?
...rms 1.2 vs 2.0
I have a 2 stores plus HQ and web integrator and mobile suite. I am
considering upgrading to 2.0. A couple of questions:
1. It is it an upgrade that can be done with only phone support (i've done
all my own installs QS2K, upgrade to RMS etc.) and is it something that
should wait until after the holidays?
2. Are there significant changes between these versions (besides the
3. I need to be able to edit customer info at each store - I'm considering
buying the customer edit add-ons - will I need to still buy this or does 2.0
allow editing customers at the store le...if else if...
any reason why this should not work correctly ? ;)))
If aWS.Range("M52").Value = True Then
aWS.Range("M80").Value = 5
If aWS.Range("M51").Value = True Then
aWS.Range("M80").Value = 4
If aWS.Range("M50").Value = True Then
aWS.Range("M80").Value = 3
If aWS.Range("M49").Value = True Then
aWS.Range("M80").Value = 2
If aWS.Range("M48").Value = True Then
aWS.Range("M80").Value = 1
Well it&...Filtering problem #2
Is it possible to return results from the same row but within differen
columns using a filter?
I appreciate your help
gaftalik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=645
View this thread: http://www.excelforum.com/showthread.php?threadid=47302
Not sure what you mean there. Can you explain 'return results'?
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
"gaftalik" <gaftalik.1wdxqa_1128441903.0178@excelforum-n...Someone else's job, someone else's template
Complete novice at Publisher, must use previous employee's template & text
for new job. Text in Word document. Am I merging, cutting/pasting to text
box, importing, or something else? Please help; desperate.
Create a text box, right-click, click change text, click text file, browse to
your Word document.
Mary Sauer MSFT MVP
"Ali" <Ali@discussions.microsoft.com> wrote in message
> Complete novice at Publisher, must u...Large Attachments #2
My Microsoft Outlook wont send large attachments (e.g.,
1M.) How can I remedy this problem?
How large are the attachments? Are you connecting to an
Exchange server or using a POP/SMTP mail system? Usually
on Exchange, the default message incoming and outgoing is
~10MB. This limit can be adjusted on the Exchange server
for you mailbox. Talk to your system administrator to
see if that is your problem.
>My Microsoft Outlook wont send large attachments (e.g.,
>1M.) How can I remedy this problem?
...Money Deluxe 05 #2
I purchased Money Deluxe 05 from the Microsoft website a week ago(downloaded
it) and paid $63.00.Once I installed the program I keep receiving a screen
asking me to upgrade the TRIAL VERSION to the Deluxe version even though I
have paid 63.00 and my credit card has been charged. I contacted Microsoft
for help and I was told that soon I will receive a letter in the mail
explaining how to get rid off that screen..nothing else...Anybody knows how
to get to the real thing and get rid off the trial version. I love the
program but this goes beyond any imagination!!!!!..Help!!!!!
...Find max value from 3 cells, return text, but 2 max values same!
I'm using a simple formula to find and return the maximum value from 3
compared columns (N, Q & T) and place that max value in column U (same row).
Equation in column U is:
SK17 EC3 PL2 Max Text
N O P Q R S T U V
3 6 5 1 6
4 6 3 3 6
5 5 5 2 5
6 1 ...DYNAMIC RANGES #2
I am looking to develop a macro that will allow me to select a range
of cells dynamically. I have created a mapping template that maps user
defined fields to native fields, but each file that I map has a
different number of rows of data. Rather than simply selecting a range
of cells statically, I am hoping that there is a macro out there that
will allow me to catch all data in a column by dynamically assigning my
range to include all rows of data up to the last row containing
information and no more. To add to this issue, not all intermediate
rows will contain data, but it is important tha...Synchronize between 2 money files
I would like to extend usage of money for my wife's finance. For this
functionality I would like to manage my finance from my notebook, which is
not always connected to same net as my wife's notebook. Therefor I would like
to have some possibility of synchronization of several accounts between these
two computers (even shared datafile could be kept on third computer with
I don't wish to publish financial data to any web server.
Is there any solution for this kind of functionality? I'm thinking about
similar solution as Ultrasoft Money for Palm uses for syn...Outlook Won't Stay Open #2
HELP! Suddenly, out of nowhere, my Outlook (2007) will NOT stay open. It
loads, and then I get the "encountered an error and must close" message. I
can't even back up my .pst file because the program won't stay loaded. Any
(Windows XP SP3)
Jan Groshan wrote:
> HELP! Suddenly, out of nowhere, my Outlook (2007) will NOT stay open. It
> loads, and then I get the "encountered an error and must close" message. I
> can't even back up my .pst file because the program won't stay loaded. Any
> (Windows XP SP3)
Ho...How do I...? #2
(In XL 2003)
I have a cell that is validated to only contain any of the numbers 1 through
What I want is to have another cell that will only accepts a range of
numbers based on the value in cell 1:
1<can only contain 1,2,3,4 or 5>
3<if A1=1, then this cell can only contain 0.01 through 0.20; if A1= 2, this
cell can only contain 0.21 through 0.40 etc.etc.>
I have tried putting a vlookup in the cell validation formula but this
doesn't seem to want to work.
Any suggestions would be much appreciated.
Try a custom Validation form...Automation #2
I have created five (5) grids within Excel consisting of correlations
comparing various commodities. Each correlation grid represents years
of data (i.e., 5yr, 10yr, 15yr, etc.).
Right now, I am manually checking each commodity across every grid to
see which other commodities are closely or loosely correlated. At the
same time, I check to see if these correlations are consistent across
all years of data. Once the correlation is manually validated, I type
the summary list into yet another worksheet.
Basically, here's an abbreviated example of what the grids look like:
AD BO BP C CC CD...EDC #2
I am getting a "Connection Error" when tryging to use EDC. It is definitely
connect to the Internet but RMS thinks otherwise.
Thank you in advance for any help you may provide!
Are you on the TSYS platform?
Are you getting:
- "Connection Error = 400" OR
- "Status Failed, Approval Connection Error"
"Daniel Suh" wrote:
> I am getting a "Connection Error" when tryging to use EDC. It is definitely
> connect to the Internet but RMS thinks otherwise.
> Thank you in advance for...Send/Receive #2
This is a multi-part message in MIME format.
Since upgrading to Exchange 2003 from Ex 5.5, when we go to Send/Receive =
we get the error 0x8004010F: The Operation failed. An object could not =
be found. My understanding from KB articles this is associated with =
Offline Address Book. It looked as if our old OAB was corrupt as when I =
went to rebuild it, it gave an error. I have created a new OAB and set =
it as default yet my send/receive still gi...How do I set up 2 email accounts with 2 differnt inboxes?
I set up 2 different email accounts in the same Outlook. Is there a way i
can have different inboxes set up for each one so I dont have to "Set as
Default" each one and have them both go into the same inbox?
tnorton <firstname.lastname@example.org> wrote:
> I set up 2 different email accounts in the same Outlook. Is there a
> way i can have different inboxes set up for each one so I dont have
> to "Set as Default" each one and have them both go into the same
Outlook version? Account types?
-Microsoft Office Outlook 2...DomainPrep #2
I have in error whwn I try to update sp2
The solution perform domainprep
can i run domainprep on existing exchange 2003 installed
Yes, you can run DomainPrep as many times as you want even with servers
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Christian" <Christian@discussions.microsoft.com> wrote in message
> I have in error whwn I try to update sp2
> The solution perform domainprep
> can i run domainprep on existin...if then else statement
On my report I have a field that I need help with. I have written an =If
statement to try and capture all of the variables, but it is too long, so now
I need to write the same expression in code. Here is what I have in my =If
statement (which resides in the Detail area of the Report):
[costtype]="05320",[txtActualCost]/[txtC...A challenge #2
Hi all you masterminds,
I've spent some time trying to solve this problem. Not exactl
because I need this, but because it's challenging. At least to me i
So, can you make a worksheet function that reverses a string? That'
Message posted from http://www.ExcelForum.com
Yes, something like this. I haven't tried to code but..
Dim variable as string, Result as string
Dim Length as integer, x as integer
Length = len(variable)
Result = Result & mid(variable,x,1)