Can an IF statement be used for 3 options?
Can I setup an IF statement to select between 3 options? For example, I have
3 divisions with 5 teams in each division. Can I setup a formula to have it
enter the proper division if I have the team name entered. For example, if I
have BOS in cell B2 how do I get cell C2 to say AL EAST. I have a tab called
divisions with the divisions listed in cells A1, A2, and A3. The teams from
division A1 are listed in cells A2, A3, A4, A5, and A6. Thanks.
Assuming your division names are in A1:C1 and teams are
in the 5 rows below each division (A2:C6), then try:
=OFFSET(divisions!A1,,MAX(IF(I...How can pass URL for website as imgeurl
Hi Every Body:
I am wondering if there is a way to retrive URL for website and pass it as
imageurl, so when the Image control renderd by the server the image would be
the website that I assigned its URL to imageurl.
any help will be apprecited
"Husam" <Husam@discussions.microsoft.com> wrote in message
> Hi Every Body:
> I am wondering if there is a way to retrive URL for website and pass it as
> imageurl, so when the Image control renderd by the server the image ...Add RSS enclosures to WMP playlist
Is there any kind of functionality in outlook to add RSS enclosures of audio
files to a windows media player playlist, or just dump them in a specific
location? I guess it wouldn't be too hard to make a VBA macro to do this,
...Can't build using DDKBuild on XP
I've got an older version of Microsoft DDK (3790.1830) for Windows
Server 2003. But tried following this link
but get the following error as copied and pasted below here:
Deleting intermediate files and output files for project 'KbFiltrProj
- Win32 Debug'.
--------------------Configuration: KbFiltrProj - Win32
DDKBUILD VERSION 3.15.38 FREEWARE FROM HOLLIS TECHNOLOGY SOLUTIONS
Comments? Suggestions? firstname.lastname@example.org
The system cannot find the batch label specified - NoWI...Changing Arbic numeral to Hindi numeral
How to change Arabic numeral to Hindi numeral in Excel 2003
...How can I search for and display actual record numbers in Access?
I have a form that has several fields to save data in for achieve
purposes. I also have a search form that pulls that data and displays it,
each in an individual line. It would be ideal to be able to click on a
search result and then on the main form have that record be displayed. I do
not know how to do that, so I was hoping to just be able to display the
record number in the search results so that you can just type it in the main
form and go right to that record number. I am unable to do that either, I
tried several combinations of displaying something like me.currentrecord for ...No longer can connect to Hotmail.......
Outlook 2007 on Vista Ultimate 32 bit........
I have a paid hotmail account that I have been happily using for 2 years
now. I always check it via outlook (2003 and 2007). In 2007, for about the
past 45 days, I would get intermittent dialog boxes asking me to confirm my
I would, and I would select remember this password and things would
continue - until about 3 days ago. Then the dialog boxes would not go away
in Outlook 2007. It constantly asked me for my password and would not
connect to my hotmail account.
I logged in to my hotmail account via the web to make sure I wa...Can not make Messenger video calls
When I try to make a video call, I get the following message:
Messenger is not available right now. Please try again later. (0x8ac70013)
The video feature has worked in the past, the problem appeared after the
forced upgrade to the latest version of Messenger. I am running Windows 7
I don't have McAfee Site Advisor installed
I don't have WMware installed
I opened a case with Microsoft Support (SRX1118889786ID) , sent various logs
as requested, was told well over a month ago that it will be escalated to a
specialist, heard nothing to date.
Any assistance to resolv...CListCtrl Changing the row height
I'm trying to change the the row height of a CListCtrl ( not the total
length of the listCtrl) i.e. I want the text to be displayed with the same
font size but the height of this text (item) should be increased. This way on
a touch screen the distance between the items is large enough to select an
item in the ClistCtrl.
Currently the clistctrl has one column, and each row data has a small icon
and text beside it.
Do you have any suggestions.
I think the only way to do it is to use a custom draw list control.
This article should explain how to do...Account format change #3
framework length = 14
seg 3 natural
in a test environment
under tools setup acct format made the changes so that
length = 14 seg1=3 seg2 =4 no change to seg3 or 4
this keeps us within the framework
ex acct 0-401-5000-399 became 0ss-401s-5000-399 s=space
I then ran the prof tools modifier
final acct 000-0401-5000-399 with the actindx of
0-401-5000-399 = to the new acct 000-0401-5000-399
only results that I have an issue with so far is the gl40200
the 2 segments that were changed had both in the table and the new longer
segm...MSWord 2003: how can I adapt US keyboard to UK English?
MSWord 2003: how can I adapt a US keyboard layout to use UK English?
The layout of a keyboard does not prevent you from typing in UK English? Set
Windows Regional settings to UK English and the keyboard to US English and
the keyboard will type what is illustrated on the key caps.
If you have an IBM PS2 keyboard and more money than sense, you could buy a
new set of key caps and replace the US caps with the UK ones.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web ...How can I translate text in many cells of an Excel sheet from English to Greek with VBA
I have a spreadsheet with thousands of rows and columns of text that
I'd like to translate into Greek.
Can anyone tell me how I might do that using VBA with some free
service or API online?
Many thanks in advance.
Kim wrote, on 01st March 2012 00:11 UTC + 1 :
> Hi all,
> I have a spreadsheet with thousands of rows and columns of text that
> I'd like to translate into Greek.
> Can anyone tell me how I might do that using VBA with some free
> service or API online?
> Many thanks in advance.
This is a quite classical...Unable to change email password
Here is my problem, I tried to change my email password by choosing Outlook
login screen "Change Password" button, but received an error message "Your
Windows password could not be changed, Please check the information and try
I have upgraded our Exchange system from 2000 to 2003 SP1 about six months
ago, and never had that problem while at Exchange 2000, here is our setup -
1. Client - Outlook 2002 SP3
2. Server - Exchange 2003 server (Windows 2003 SP1) and Active Directory
server (Still on Windows 2000 SP4).
3. We have Novell servers, so each works...Can't connect to Exchange server
Hello, I am having a problem configuring an account on
Outlook XP. I can ping the Exchange server, both by IP
address and by host name. When i try to configure the
client to connect to the Exchange server I get an error
saying that it could not locate the server. I have even
uninstalled and reinstalled, repaired, done everything I
could think off but I can not get it going. Obviously
there is something I'm not doing right. Any help would be
Rather then typin in the name of the exchange, can you
connect if you use it's ip address?
This sounds like a w...Change History (Log)
Is it possible to retrieve information about inserted, deleted or
updated records in an MS Access database from system tables? In other
words, to read and interpret the transaction log. I am not able to
change the database structure and there is no current logging
mechanism, but I need to detect the changes made by any other client.
No. JET (the data engine in Access) does not support transaction logging.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot...Outlook form - Checkbox
Let's assume I have 15 contacts. 5 of these contacts are clients and I would
like to have a different background color of the contact form for these
contacts that all employees know that these contacts are clients. The
contacts are stored in the Public Folders.
Any ideas how I could add a checkbox (add a custom tab) that if the checkbox
is checked that the background color of this form would change (> all
pages/tabs > General, Details, Activities, etc.)?
You can design your own custom contact form for this;
Tools-> Forms-> ...Can't install Office 2010 beta
I downloaded Office 2010 from Office Online and i tryed to install it, but
not. It won't open. I check in CTRL+ALT+DEL under processes: it's not there.
HOW to install it? :(
Try posting to the Office 2010 beta forums here:
**please reply to the newsgroup so others may benefit**
"confusedguy" <email@example.com> wrote in message
>I downloaded Office 2010 from Office Online and i tr...Excel 2003
Hi - quick question, if you have a moment - I've got a (tall) column
of names of the format:
I want to convert them to the format:
Is this possible in Excel 2003?
Thanks very much -
Assume they start in A1, insert a new column B or use the one you
have if it is empty, then in B1 put
=MID(A1,FIND(" ",A1)+1,255)&", "&LEFT(A1,FIND(" ",A1)-1)
Select B1 again, move the cursor to the lower right corner of B1 and when it
from a thick cross to a think double click and copy down the formula.
S...Who can make film from PNG files?
Does anyone here maintain a list of graphics people who can generate film
positives from Publisher PNG files for 'precision' silkscreening (tight
tolerance, not for tee shirts)? OR... does anyone have positive (pardon the
pun) experience converting a Publisher file to a PDF for this same purpose?
Heck, do they even make film anymore?
Look for help and links here
Mary Sauer MSFT MVP
"Jim Wood" <JimW...Change file name #2
Hi, I've been searching for a solution to the following problem for more than a week. I've posted it here a couple of times, and got some good ideas, but unfortunately they did not work. The variable "myfolder1" has the correct value, followed by ".xls" as it should.
I'd be very thankful if someone could find my error. This is the original question:
I am new to Exel, and i cannot find my error in the following script.
The error is:
Run time erroro '9'
Subscript out of range
and it always stops on the "windows(my folder1).activate" line...Changing Case #3
I have a large excel document that has been typed in upper case and I wish
to change it to Proper case ie. with initial capitals only. Is there an easy
way to do this, please.
The easiest way is probably to download the free Excel add-in "XL Extras"
It adds menu commands on the Format menu that will change case in
whatever cells you select - Proper, Upper, Lower and Sentence case.
Plus it does other nice stuff. Comes with a Word.doc install/use file.
San Francisco, USA
"Robert ...Excel can't do hex
I would like to be able to define a group of cells as (hex, oct, or
bin). The effect would be that when I input numbers, or the cell
displays numbers they would be in the chosen format.
I set up cell A1 as a hex "type" cell. I set up cell B1 as a decimal
"type" cell. In cell B1 I put the simple formula (=A1). Now I enter
"ff" into A1 and "255" pops up in B1.
I understand that there are hex2dec, dec2hex, bin2dec, ...etc
formulas. These, however, aren't much help when you are trying to work
with a different base across the whole spreads...Can't select text in input control
I have created a custom page that works fine within CRM. The strange
thing is that I can't select (highlight) text in a textbox control. I
created the page using an asp:TextBox control and a regular HTML Input
control set to type=text. For some reason I can't select the text using
the keyboard or mouse in either case. The standard CRM pages don't
exhibit this behavior. Does anyone have a clue what's going on?
onselectstart="return false;" Not too smart.
...Can not see a particular sub folder under public
We use exchange 2003 with outlook 2003 client
When I use outlook 2003 client, I can see all public folders except 1 sub
when I login thru OWA, I can see that folder also.
I made sure all the permission are there, and besides I have all
administrative rights in exchnage and AD
Public Folders will read the LOGGED in account for permissions.
Are you logged into the machine with the same entity as the account
that is the owner?
example: My Active directory account called AdminNikki is owner
of all my public folders. But if I log into my machine as
NikkiTes...Why do margins change when a file is emailed?
I am setting up monthly transaction worksheets for a client and then emailing
them for her to print out. When she opens the email attachment and checks
the print preview the top and bottom margins are not the same as what I set
them at. Is there a way to correct this?
I haven't seen this occur myself,
but it may come from the use of different screen resolutions or different printers.
San Francisco, USA
wrote in message
I am setting up monthly transact...