If statement with formatted text
Is there any way to have an if formula such as:
If (A1="Active", "KAE",KPE")
where the two letters after the K are formatted as subscript?
The best I've done is to paste a picture over the cell. The picture's
formula refers to named formula that selects one of two cells, the one with
correct string. One cell contains KAE and the other KPE with the subscript.
However, it means that I'm using a picture and it would be much nicer if I
could just do it in an If formula.
I hope that makes some kind of sense, and thanks in advance for your help.
D...How to print a graph of x=y at 45 degrees
How can I make it appear correctly on paper?
Set up two sets of points:
Plot them with an x-y scatter chart, line style. Set the x and y axis
scales the same, if necessary, to get the resulting plot to be at 45�.
Print it, and hope for the best.
mvpearl omitthisword at verizon period net
"gordon158" <email@example.com> wrote in message
> How can I make it appear correctly on paper?
...active X control
I have a calandar (active x control) on my form.
Does anyone know how to link/sync it to a bound control; i.e., when a
user chooses a date control, the calandar appears, and when a date is
selected it populates into the requisite field.
Arvin Meyer, MCP, MVP
"alex" <firstname.lastname@example.org> wrote in message
>I have a calandar (active x control) on my form.
> Does anyo...Extracting Time from a cell that has both the date and the time
I could do with some help here please. I am trying to extract the time
only from a cell that has both the date and the time. Can anyone
suggest a solution?
Thanks in advance. :confused:
Hani Muhtadi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26794
View this thread: http://www.excelforum.com/showthread.php?threadid=466177
If you just wish the time to display, set the cell format to Time.
If you wish to use the time portion then =A1-Int(A1) will give you...How do I sort data by date excluding time
I would like to sort a database by date and transaction type. The problem is
the data sorts by time, even though the field is formatted to show date only,
with the transaction type not sorting within the date because it shows up in
the time order. How do I get rid of the time?
If date/time column is A then you have to use an empty helper column filled
with formula =INT(A2) and sort by it.
„markd” ezt írta:
> I would like to sort a database by date and transaction type. The problem is
> the data sorts by time, even though the field is for...IF(This=2 and That=1,X,Y)
Im comparing 2 values per. I need to evaluate if THIS = 1 and THAT = 2,
then 1 otherwise 0
How do I do that in an expression? I always need to evaluate BOTH and they
both need to be true.
Any help would be appreciated.
This is what I guessed, but doesn't work, surely there must be a method to
evaluate both as the same time?
IF R14 is 1 AND S14 is 1 then 7, otherwise 0 as:
Use the AND() function:
"No Spam" <email@example.com> wrote in message
> Im...Bar chart & Category (x) axis labels #2
If you make a bar chart in Excel 2003, and have two
columns of text as Category (x) axis labels, the first
column is shown vertical and the text in the second column
is shown horizontal in the chart.
If you open/make the same chart in Excel 97, the text in
both columns is shown horizontal.
If there is a lot of text, it becomes unreadable when it's
Is this by design or can it be fixed somehow?
...Time to text conversion
I have Mac's version of Office (Office 2004), but it shouldn't matter..
I have a column in a table containing times (for some events). Data
found in the cells looks like this:
2) "20:00/22:00" (starting/ending time)
Excel has automatically formated type 1 cells as "time", and type 2
cells as "text".
I need all the cells to be formatted as "text". How?
If i change the formatting of a cell, it displays something like
"0.833333" (20.00 divided by 24). The only solution I came out with is
copying the whole co...Re: too long execution time and access violation error
Oh ... and one more thing ... is CPlex one of your classes? If it is here's
the problem ...
CPlex::FreeDataChain() line 45 + 15 bytes
It appears it's doing a delete that is causing the access violation.
"KS" <firstname.lastname@example.org> wrote in message news:...
> The reason why it's taking 55 seconds is because you're running the
> application in debug. When running in debug, MFC has A LOT of overhead if
> you're doing a lot of new's or a lot of delete's. This is a because MFC
> does a lot of error checking to make sure you're not deletin...Saving Excel files takes a huge amount of time
Excel takes 5-10 minutes whenever I try to save the file after making the
smallest of changes, even if I add a value to just one cell. Excel is using
98 or 99%
of the CPU during these 5-10 minutes.
If I do a save as the file gets saved instantaneously. The save time for
subsequent saves also decreased. Then it slowly started creeping up and now I
am back at a situation where it takes 5-10 minutes
The file size is 3MB with 2 tabs, lots of formulaes, also formulaes cross
referencing the tabs. This is the raw data file, which I am having problem
There are 2 other excel files...Trying to change x-axis date range
I have a scatter chart with dates on the x-axis and data on the y. When
trying to change the range of my x-axis, I right click on the x-axis, click
"format axis" and for "Minimum" and "Maximum" I click "Fixed" but it will
only let me enter dates in the number format (i.e. 39983 instead of
6/19/2009). This is really annoying because I am constantly changing ranges
to zoom in on the data and need to think about what the number format would
be. I didn't have this problem with the earler version of excel (2003), but
it started as soon as my offi...CRM / SBT 6.x
Hello All & Greetings.
I am looking for any material / Case Studies, etc. of
Installing, Configuring & CUstomizing MS CRM and SBT Pro
and would appreciate any material would be of immense help.
thanks in advance.
I would go to www.greatplains.com and also microsoft.com/crm and have a dig
"R. Kishan Boddapati" <email@example.com> wrote in message
> Hello All & Greetings.
> I am looking for any material / Case Studies, etc. of
> Installing, Configuring & CUstomizing MS CRM and ...excel charts to ppt: x-axis creep
Operating System: Mac OS X 10.6 (Snow Leopard)
The x-axis of large data-point line charts 'migrates' when copied to PPT; that is, the starting date in the x-axis creeps up from, say, 1973 to 1977 in charts copied to PPT. Any remedy for this?
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
On 1/8/10 6:20 PM, in article 59bb0604.-1@web...Office v X Professional, Service Release 1
Can someone please tell me what updates I should install on SR-1? I am
unable to tell if SR-1 is newer or older than 10.1.3.
See here for what you need, and how to find out. Sounds like you need
10.1.4 and 10.1.5.
"Brent Bosin" wrote:
> Can someone please tell me what updates I should install on SR-1? I am
> unable to tell if SR-1 is newer or older than 10.1.3.
On 4/19/04 1:55 AM, in article BCA8E218.firstname.lastname@example.org, "Brent
Bosin&quo...why do mailbox limits take time to come into effect?
If i change someones limits, they cannot imediatly send messages (it
still says that they have exceeded their limit). why does this take
approx 1 hr? The user is connected to the exchange server (1 of 1).
It should not need time to replicate, because it should not have
anything to do with AD, DC, GC.
What am i missing?
This sounds like
"aaron.whittaker" <email@example.com> wrote in message
> If i chan...excel numbering #3
> someone had asked a similar question, someone had posted a resolution,
> am just a carrier!
> Private Sub Workbook_Open()
> Const DEFAULTSTART As Integer = 1
> Const MYAPPLICATION As String = "Excel"
> Const MYSECTION As String = "myInvoice"
> Const MYKEY As String = "myInvoiceKey"
> Const MYLOCATION As String = "A1"
> Dim regValue As Long
> With ThisWorkbook.Sheets(1).Range(MYLOCATION)
> If .Text <> "" Then Exit Sub
> regValue = GetSetting(MYAPPLICATION, MYSECTION,...Office X 10.1.2 to 10.1.5 updates
Each time that I'm trying to install these updates, I get
the error 11002:2'-15. Nothing is running even my anti-virus.
Does somebody have an answer.
On Mon, 23 Feb 2004 21:51:05 -0500, Doggy wrote
(in message <firstname.lastname@example.org>):
> Each time that I'm trying to install these updates, I get
> the error 11002:2'-15. Nothing is running even my anti-virus.
> Does somebody have an answer.
> Thank you
It's been said, and it seems to have worked for me, that you need to have all
internet access disabled.
Tim M...excel graph is only showing numbers not words-how do I change?
I have a chart that has a part number for the x axis. The chart area then
shows the quantity of scrap and the next line shows reason for
non-conformance. This chart will not recognize the reason for the
non-confrormance. This is indicating "0" for them. How do I get them to
indicate the actual words?
...printing one lable at a time on sheet with six
I have a custom lable in publisher, I want to be able to print one only on a
page of six at a time, like I can with Word lables. or import this pub lable
into words lables list where I can print one on the page
Start with a new work area and set the columns and rows to mimic the sheet
Create a single label in the location that would use the label in the sheet.
Put sheet of labels in the printer, Print.
Don - Publisher 2000
"RMC" <RMC@discussions.microsoft.com> wrote in message
>...Office v. X program unexpectedly quits after doube-click
After I double click on an Office v.X program, expect Entourage, the
splash page appears, reads font menu, then quits. I already checked
out the Mactopia database and its font issues posting. I am running on
OSX 10.2.8, G4 1.25 GHz 256 RAM.
I have tried the following:
1. Compared duplicate fonts between User fonts and Library fonts (not
the System fonts folder)
2. Updated all Office software to v. 10.1.5
3. Reinstalled Office
4. Removed Microsoft Prefernces from User folder, and allowed them to
If ANYONE has ANY info or has experienced this before, please pass on
t...URGENT ** x & z report display zero
I attached printers and cash drawers eposon tm-88iv printeres and generic
Now my X and Z reports dsiplay zero totals
I have read everything I can find to no avail, can anyone suggest a solution
everythign worked fine before i attached the printers and cash drawers
"Ian Yorke" wrote:
> I attached printers and cash drawers eposon tm-88iv printeres and generic
> Now my X and Z reports dsiplay zero totals
> I have read everything I can find to no avail, can anyone suggest a solution
> everythign worke...Red x's in All Outlook E-Mails
Suddenly from late last week (probably after last Tuesday's MS security
updates) I am seeing Red x's in HTML messages. There is now no info bar
to allow me to "allow" the contents to be displayed. It is not the
normal settings within Outlook to display pictures. Something changed.
Outlook 2007 on Vista Ultimate. Today put Office SP1 in and did not
correct this fault. Even with the "sender in my trust list", still it
doesn't display the missing parts
> Suddenly from late last week (probably after last Tuesda...How to format text and numbers as custom
How do you format a drivers license number? For example:
Hxxx-xxx-xx-xxx-x, where x represents any number, but "H" represents any text?
Do you have to use a macro? If so, does anyone have the code for this
If always H then custom format of "H"&000-etc should do it
or format as text and type in the - - - -
or a worksheet change event to convert based on any entered letter and
numbers entered witout - - -
"Julian Ganoudis" <Julian Ganoudis@discussions.microsoft.com> wrote in
message news:198...Excel formual IF statement Help
I am trying to make this IF statement work
On Sat, 01 May 2010 20:11:13 GMT, "Cerealkiller" <u59737@uwe> wrote:
>I am trying to make this IF statement work
...store.exe consuming 99% of processor time
Our Exchange 5.5 box had a virus, which was quarantined and removed by
Symantec AV. I had to delete and recreate the edb.chk file and also run
It allowed me to start the Information Store and Internet Mail services.
Unfortunately, the store service is consuming 99% of the processor's time.
Is this normal? If not, what is happening?
Thanks in advance,
"Craig Buchanan" <email@example.com> wrote:
>Our Exchange 5.5 box had a virus, which was quarantined and removed by
>Symantec AV. I had to delete and recreate the edb.chk file...