Hide Chart Formulas
Is there any way to hide the chart series formula that displays when you
click on a data point on a chart?
I imagine you could hide the formula bar (Tools | Options... | View tab.
Custom business solutions leveraging a multi-disciplinary approach
"Wayne Cressman" wrote:
> Is there any way to hide the chart series formula that displays when you
> click on a data point on a chart?
> Wayne C.
True but that's not my issue. If you click on the datapoint the formula
appea...Formula to return numerical, text result?
I need to create a formula that based upon three possible factors, wil
return one of two calculations or a text message.
If cell B="Good", the formula in cell C returns "Text"
If cell B="Better", the formula in cell C returns cell A*.3
If cell B="Best", the formula in cell C returns cell A*.5
Thanks in advance for any tips
burgeon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2023
View this thread: http://www.excelforum.com/showthread.php...Formulas #4
Where would be the best place to start looking at different formulas used in
I have a series of arguments etc that I need to work out but currently only
have basic knowledge. Is there a site someone could please put me onto? I
have been chucked in the deep end with a staff member leaving who has
designed an excel program that formulates quotes for our business. Any
No need to post to more than one group. Reply down the road at New
You could look at:
Also if you apply direct to me you...help with formula please
This is for scoring duplicate bridge
Have five scores
1 40 1.5
2 100 3
3 40 1.5
4 400 4
5 -60 0
Want to award points from 0 to 4 as shown.
given second, what would a formula be in each cell of the third column
that would produce the score? ties are common and scores are given to 1
dec place by halves.
I have pretty much got nowhere with this so far.
Thanks for any help
On Fri, 14 May 2010 17:47:50 -0500, John <firstname.lastname@example.org> wrote:
>This is for scoring duplicate bridge
&...Using contents of a cell in a formula
Hi, I'm trying to use the contents of a cell (as opposed to the actual cell)
in a Formula. For example – in the following Statement:
Instead of using ‘PRICES!D$32848:D$34120’, I want to use the contents of
another cell – lets say Cell A2’
Cell A2 would contain the character expression ‘PRICES!D$32848:D$34120’
So the statement above would read something like:
=AVERAGE(IF((? A2 ?),PRICES!P$32848:P$34120))
How do I get the statement above to recognize the contents of cell A2
instead of cell A2?
I know I could create ...Shortcut to get into formula bar
Does anyone know if there is something I can type on the keyboard in order to get my cursor into the formula bar? Sometimes having to use the mouse is a little inconvenient.
Use xdemechanik <at>yahoo<dot>com for email
"Jesse" <email@example.com> wrote in message
> Does anyone know if there is something I can type on the keyboard in order
to get my cursor into the ...hide worksheet
is there any way to hide worksheets in a workfile for eg - i have to hide 5
to 8 worksheet in a workfile consisting of 10 worksheet.
"Ankur" <Ankur@discussions.microsoft.com> wrote in message
> is there any way to hide worksheets in a workfile for eg - i have to hide
> to 8 worksheet in a workfile consisting of 10 worksheet.
Yes, there is, and it's simple & clearly labeled. Explore the Excel menus
until you find the word "Hide". Or, press F1 for the Help system and search
for the w...Named Range in a External File Formula
I have a simple VBA program that when run, looks at a date in a
particular cell and updates 6 named ranges with specific file names it
uses based off of that days date.
I have a folder for every day of the week and inside there are 6
exactly named files:
"Tech Name - Service Log - Date.xls" (Date is in mm-dd-yyyy format)
The named ranges are "TechName1File, TechName2File, ect...."
How do I make this work:
After successfully running the macro to fill the named ranges, the
named ranges will look like this:
\\Server\Folder\Folder\<Year>\...how to hide an ActiveX control?
i have an ActiveX control, written in C++, which has the
OLEMISC_INVISIBLEATRUNTIME flag set, yet when i display the web page
it is attached to, i get the familiar "red cross" graphic in the
middle of the screen - how can i hide the control so nothing is
displayed at all?
can u set the size of ur control as 1x1 pixels
"bhu Boue vidya" <firstname.lastname@example.org> wrote in message
> hi there
> i have an ActiveX control, written in C++, which has the
> OLEMISC_INVISIBLEATR...RECEIPTS: Hide up item look up code in receipt
My buyer and I are wondering, how would you change the receipt to
hide/not show the item lookup code in the receipt.
Any help would be appreciated.
its very easy to do so, make a backup of receipt.xml file under:
C:\Program Files\Microsoft Retail Management System\Store
Operations\ReceiptTemplates or whereever you installed the program.
Then open the receipt.xml file in notepad and find the
"Entry.Item.ItemLookupCode" and just cut from whole code whereever it
appears and then save the file. then again to to SO Manager program> Database
> Regi...Extending Excel with more formulas
Subject: Extending Excel with more formulas
Is there a way to extend Excel foruma base to include more formulas?
Yes, by writing UDFs (User Defined Functions) either within VBA or an
Andy Wiggins FCCA
Excel, Access and VBA Consultancy
"death" <death@SupportX.com> wrote in message
> Subject: Extending Excel with more formulas
> Is there a way to extend Excel foruma base to include more formulas?
&...Apply concatenation formula to column
An extremely basic question: I have figured out how to concatenate several values from a particular row (e.g. =F2&"."&G2) to get what I need in H2. How do I then apply the same formula for the entire F and G columns to show the results of each row in it's respective M row? I assume I can do this without writing a new formula in M for each row, but I've been trying various search phrases in Excel help without success. (Good thing I at least remembered "concatenate" is what I wanted to do... .
Hope that makes sense. Thanks for any help
Wi...Cell reference in formula as range
I have a formula in my spreadsheet that looks like:
=IF(D11=0," ",IF(C11<D11,"Not Enough Hours",INDEX('PF Kintanas Pivot
In cell E1 I have the following text: gtalbo
In the PF Kintanas Pivot Tables tab I have a named range with the name: gtalbo
When I try to use the above formula I get the #Value! error. If I
substitute the actual name of the range in the formula it works:
=IF(D11=0," ",IF(C11<D11,"Not Enough Hours",INDEX('PF Kintanas Pivot
Is it possible to have an account be open, and still have it hidden in the
account list? If so how?
No. Open = visible in account list.
"Shhh" <email@example.com> wrote in message
> Is it possible to have an account be open, and still have it hidden in the
> account list? If so how?
...Formula Error.. help !
is giving me an error... I cant see why..
Look up OFFSET in help, you seem to be using it incorrectly. The arguments
Reference is the reference from which you want to base the offset.
Reference must be a reference to a cell or range of adjacent cells;
otherwise, OFFSET returns the #VALUE! error value.
Rows is the number of rows, up or down, that you want the upper-left cell
to refer to. Using 5 as the rows argument specifies that the upper-left cell
in the reference is five rows below refere...Simple formula
Hi, I'm a new to Excel so please excuse my ignorance in advance.
I have data in Column C that I need to multiply with Column D. I know
(for example) I can get a result by placing the formula: =sum(C3*D3)
in cell E3.
But, I have very long columns of data and I don't want to type in
=sum(C4*D4)in cell E4, =sum(C5*D5) in cell E5 etc.
My question is; can I use a wildcard for the column number and then
just paste this formula in each E cell?
On Fri, 22 Jul 2005 14:02:51 +0100, PigPOg <firstname.lastname@example.org>
>Hi, I'm a new to Excel so please excuse my ignoranc...* Need serious help with formula/function *
Here's an example of what I need...
D3 100.0000 <---------------- Random number entered
<---------------- 100.0000 falls
D9 113.0625 in between here.
D19 _________ <---------------- Target number
I need excel to recognize where the random number ( D3 ) falls on the
s...how to make a formula to be "&"s formula
could anybody tell me something about the way to make a formula to be "&"s
i mean that, for instance ,make =D22-G28-D26 to be =D22&" $B!](B "&G28&" $B!](B
for i like the show the detail of the formula,instead of the result.
Dnia Wed, 17 Nov 2004 21:47:43 +0900, EXCEL NEWS napisał(a):
> could anybody tell me something about the way to make a formula to be "&"s
> i mean that, for instance ,make =D22-G28-D26 to be =D22&" − "&G28&&q...Formulas not calculating correctly
How do I get formulas to calculate correctly?
I have used the following simple formula -
where t20 = =IF(N20>100%,"0",K20-M20)
z20 = 917,000
n20 = 99.04%
When I do the math, it should total 3,668,000, yet my total in excel is
3,457,090. Why is excel calculating this incorrectly?
I think its rounding problem if type figures given into excel it calculates
3668000 I presume figures in row 20 are sums of ranges
> How do I get formulas to calculate correctly?
> I have used the following simple formula...Remove characters from a text string using a formula
I need a formula where I can remove characters such as . - space or _. These
characters can show up anywhere in the text string. i.e.,
123-abc should be 123abc
123 abc should be 123abc
any help would be greatly appreciated,
Try this to remove periods(or decimal points), dashes(-), spaces, and
underscores( _ )
"duncrbrt" <email@example.com> wrote in message
news:8CAF...WHATS THE FORMULA FOR Daily log of calories and fat percentage
...What's wrong with my array formula
In A1 I have
In D1 I have
In E1 I have
I want to match the value in Col A with Col B and were equal copy from Col E
that is next to the matching value in Col D to Col B next to the matching
value in Col A. Did that make any sense??
Here what I'd hope for where the numbers are column A and the letters are in
1...Formula with to Criteria
I have a row of numbers in Coloumn B ranging from 1 to 200 what I want is a
formula in cell A1 that will do the folowing.
Look at my range in coloumn b for example B1:B200 and countif the number is
the coloumn is over 25 >25 and below 100 <100.
I can do countif functions but don't know who to do the above or below part.
Any help would be apperciated
OR, in Excel2007+ only
=COUNTIFS(B1:B200,">25",B1:B200,"&g...Cell displays wrong total after copying formula
Sometimes, when I copy a formula (usually the sum of a range) to another
cell, instead of getting the sum of the new cells, I get the sum of the old
cells. The formula is not set to absolute. For example, I copied the forumula
=SUM(D6:D9) from cell D11 to cell C11. The formula in C11 is now =SUM(C6:C9).
But, instead of calculating C:6:C9, the cell is displays the total from the D
Has anyone else encountered this problem? Does anyone know if this is an
issue with Excel? (This issue is difficult to search for.)
Make sure Calculation is set to Automatic (Tools/Options/Calculation....What formula do I use to calculate compound annual growth rate (C.