Having a cell with '<' sign included within a function?
If there is a '<' sign in a cell, can the cell be included in a function?
Not when the function expects a numeric value.
You could use MID(A30,2,LEN(A30)-1) in place of just A3 which has <5.
For example SQRT(MID(A30,2,LEN(A30)-1))
or 2*MID(A30,2,LEN(A30)-1) which is not a function but a formula.
Bernard V Liengme
remove caps from email
"Michelle" <Michelle@discussions.microsoft.com> wrote in message
> If there is a '<' sign in a cell, can the ...About ON Mobile functionality
I've used ON on my desktop for a long time at work. I just got a phone
running Windows Mobile with ON mobile on it. I wanted to try using ON at
home for synching with my phone, so I downloaded a trial version of it. It's
useless. Many of the menu options are disabled. I can't get it to synch
with ON on my phone, another post suggested installing it into the phone from
ON desktop (even though it's already there), but I can't since that menu item
is disabled (there's an option on some of the menus which reads, "explain
choices on this menu" wh...How to add function to ie to parse html of current web page??
i am looking for a way to add a function to ie7 or ie8 which parses the
html code of the current web page and then copies parts of it to the
clipboard so the data can be used via copy & paste.
Any hints on how to add this kind of functionality would be highly
> He there,
> i am looking for a way to add a function to ie7 or ie8 which parses the
> html code of the current web page and then copies parts of it to the
> clipboard so the data can be used via copy & paste.
> Any hints on how to add ...IF Function with Dates
I hope someone can help me. I would like to create an IF function for dates
in my worksheet. I have a Start Date column and End Date column. If the
date in the Start Date and End Date falls within the Fiscal Year(06), then I
want to display a 1, otherwise a 0(zero).
A1=7/01/06 (Start Date); B1=6/30/10 (End Date)
FY06 is from 7/1/2005 to 6/30/2006
What I have in C1 is =IF(AND(A1>=7/1/2005,B1<=6/30/2006),1,0)
My result for FY06 is 0, but that's not correct because the End Date is not
until 12/31/2010, so it falls within the FY06. I want this formula to...functional currency
I set up a new company, and copied some data over. When I try opeining an
item its asks me to set the functional currency. I went into setup and tried
to set it, it saves doesnt give me any messages but it is still asking me to
set the functional currency. This is a new company that was just set up, any
direction on this would be great. Thanks!
If you go back to your window after you saved can you see the change you
made, or it's back the original value?
"Dave" <Dave@discussions.microsoft.com> wrote in message
I want to set the pidlRoot member of the BROWSEINFO structure to
a default location. How do I get a PIDL from a path represented
by a text string like this: _T("C:\Program Files")?
I'm not certain about the pidl for an arbitrarily named folder, but if your
real interest is the "Program Files" folder, then you shouldn't use a text
string anyway, since the text is user-selectable and in fact changes based
on language locales.
For "Program Files" and other special folders, you can get the pidl using
the SHGetFolderLocation function, passing in a CS...IS functions
Sorry to raise this issue again, but I'm still having trouble using the IS
functions, here's the latest manifestation (running Excel 97)
This formula works perfectly fine in my spreadsheet:
=IF( ISNA(MATCH(0,A1:H1,0)),"Zero NOT found","Zero found")
However, a similar statement in VBA code generates an error message if '0'
is not present (e.g., N/A), but works if '0' is present.
Set rng = Range("A1:H1")
If WorksheetFunction.IsNA(WorksheetFunction.Match(0, rng, 0)) Then
MsgBox "Zero NOT found": Exit Sub
MsgB...Nesting Address function within Index function
I'm trying to use a nested Address function within an Index function, but I'm
getting errors. Here's a sample of my function which is giving me an error I
cannot figure out:
With this function, I'm trying to get the contents of the first row, second
column from an array that begins in cell A20 and ends in cell D30. I want to
use the address function because I will not know the beginning and ending
cell of the array.
> I'm trying to use a nested Address function within an Index function
>...Flawed scatter plot function
I always use scatter plots to visualize my data and after I upgraded to Excel
2007, something weird started to happen. What I do to is to Insert -->
Scatter --> "Scatter with only markers", then I get a blank chart. Now I
select the chart and type in "Series(, x range, y rang, 1)" and hit enter,
now it gives me a chart with both markers and lines, so I have to go back to
Insert --> scatter --> "Scatter with only markers" again and get rid of the
connecting line. I'd love to hear suggestions on how to fix this, this is
I don...If function using cell format as the condition
I would like to create an "If" logical function formula, where the "true"
condition is based on the format of the cell.
For instance, if cell b3 is formatting with a fill color, then add that
number; if not, then add zero.
Can anyone help?
That will need VBA, unless the fill colour is derived from conditional
formatting (in which case you could impose an equivalent condition).
"Janie" <Janie@discussions.microsoft.com> wrote in message
>I would like to create...functional currency #3
i entered the functional curreny then GP says
check links for Multycurrency setup file to update currency field !!!!!!!!!!!!
i went to made a purchase order entry , GP says
order processing setup is missing or dameged !!!!!!!!!!!!!!!
It seems Purchase Order Processing never setup, go to Tools --> Setup -->
Purchasing --> Purchase Order Processing, and click on OK.
Mohammad R. Daoud
MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
Great Package For Business Solutions
I would like to change the name of the "cancel" button. Is that
possible with Subclassing, Superclassing, etc.?
Maybe this article can help you:
"Bruce Arnold" <b_a_r_n_o_l_d@b_l_a_s_t.n_e_t> ha scritto nel messaggio
> I would like to change the name of the "cancel" button. Is that
> possible with Subclassing, Superclassing, etc.?
And this too:
http://www.codeproject.com/dialog/browse...DatePart Function in Reverse!...
I have a problem in that I have inherited a database that holds the date
value as a dayofyear number. So December 25 would be = 360
I know that DatePart will find the dayofyear (eg datepart("y",#25/12/2008#)
would return 360)
Does anyone know how I can use the value 360 to find the date?
many thanks for your help.
Using DateAdd or DateSerial functions.
DateAdd("d",TheNumber-1,#1/1/2007#) The base date is the first day of the
year - whichever year you are using
Access MVP 2002-2005, 2007-2008
Center for...ERM should have a "cleared difference" functionality like GP BR
Like normal GP Bank Rec - within ERM you should be able to enter differences
within ERM (Match Transactions window) whereas currently if the amounts do
not match in this window you end up having to delete the statement line in
the Match Transactions window, entering an additional transaction and then
going into the CBM Transaction Reconcile window to reconcile these 2.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. ...Logic Function
I am attempting to create an IF function which test whether or not a
cell is empty. If the cell contains data, it will contain a text
The form I need it to take is if(A1 is empty, "--", C1*0.005).
I am not sure how to specify the IS EMPTY test of the contents of A1.
Thanks for any help.
IF(A1="", "--", C1*0.005)
"Paul Axelrod" <firstname.lastname@example.org> wrote in message
> I am attempting to create an IF function which test whether or not a
> cell is empty. If the cel...How can I use engineering functions in Excel 2003
How can I use engineering functions in Excel 2003 in my package (excel 2003)
they are absent.
You mean the functions in the Analysis Toolpak?
If yes, tools|addins|check analysis toolpak.
(You may have to have the installation CD available if you didn't install this.)
> How can I use engineering functions in Excel 2003 in my package (excel 2003)
> they are absent.
...Can I call built-in functions from my add-in function?
I have a new add-in module (test.xlam) in Excel 2007.
One of the functions it contains is:
Function Circum(radius As Variant)
Circum = 2 * Pi() * radius
If I put "=circum(3)" in a cell in a worksheet, I get the Compile
error: "Sub or Function not defined" with the Pi() highlighted.
What's odd is that wjen I coded it as "pi()", it corrected it to
"Pi()", so it seems to know about the function.
If I code "=pi()" in a cell in the same workbook, I get the value of
What do I have to do to be able to call built-i...If Function #18
I want to put a sum in the "value if true".
What i want to achieve is that i add 10% to the value of th
neighbouring cell if another cell contains yes and to copy the amoun
form the first cell if the second cell says no. I hope this make
sense. You were all very helpful last time i posted a question so
hope it works. Got to impress the boss!!
Tilly's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2180
View this thread: http://www.excelforum.com/showthread.php?threadid=383...Lookup Function #9
When using a lookup function, it is referencing the text of the formulas in
the table array cells instead of the result of the formulas. How do I
Either you are in Formula View or the formula cells are formatted as text.
Changing the Format alone won't do the trick.
For the first, hit CTRL + `(back quote above TAB key) to toggle View Formulas
For the second, Format the cells to General then F2 and ENTER to see results.
If you have already done a great whack of these formulas, select all and
Replace All and OK.
Gord D...now function
I got a cell A1 with a now function =now() which gives the current time.
Cell A2 has a time that is entered, and cell A3 has an if function that
compared if(A1>A2,"","Do Something"). However, the if statement is true all
the time even if the time is cell A2 is a later time than A1. I changed the
format in cell A1 from a time format to a general and it turn out to be a
big number. Otherwise, I changed the time format in cell A2 into general
and it is a very small decimal number. How do I get around this, may with a
mod function or something?
NOW gives both ...Function help please.
I am a teacher and have an excel spreadsheet (2003) with student's marks in
various columns. Each column represents a quiz/exam/OP or assignment and they
are all out of different totals. I need to know how to:
1) reduce each column to it's percentage value (example to follow) and,
2) to sum up totals from each row into a percentage final mark.
Assume we are using A1 as the first 5% piece of information, so the marks in
the columns would go from: A4:A34, B4:B34, etc
Thanks in advance,
5% 5% 15% 30% 30% 15%
26 marks 20 marks 40 marks 60 marks 55 marks
Qu...Win7 Virtual WiFi
This is regarding the following NDISTest requirement in Win7 premium logo
certification of WLAN miniport driver
VWiFi: Two concurrent STA connections
Since the wdk documentation states that virtual wifi is not possible without
a hosted network
Does the above requirement means that there should be three ports created in
the miniport driver in the following manner
PORT 0 -àDefault port in client, [OP STATE]
PORT 1 -àFor Hosted network(Soft-AP) , [INIT STATE]
PORT 2 -àVSTA operating in client mode , [OP STATE]
1) Can the VS...Syntax for IF function
I would like to average the values in column B that lie between 2 value
in column A. What I have so far is =average(if($A3:$A100, ...value i
column A is less than 46 and greater than 34..., "" ""). I have bee
unable to express the second term with the correct syntax. I assume
that it would be ,<46>34. So what is it?
Thank you in advance
of course you realize that this is an array formula that must be entered
&qu...Another Len function not working
Thanks for your time
I have this code:
Private Sub txtUser1_AfterUpdate()
On Error GoTo txtUser1_AfterUpdate_Error
If Len(Nz(Me!txtUser1, "")) = 0 Then
MsgBox "does it work"
On Error GoTo 0
Err.Description = Err.Description & " In Procedure " &
"txtUser1_AfterUpdate of VBA Document Form_LoginTest"
Call LogError(Err.Number, Err.Description, "txtUser1_AfterUpdate")
It will work if there is a space entered in the text bo...Logic Function Help�
I am trying to incorporate an IF Logic function into my worksheet bu
it doesn�t seem to work.
I am working on a body fat calculator, and one of the components o
this calculator is the gender of the individual. I have a drop dow
menu in a cell, with Male and Female for choices. This is in cell B2.
In cell B9, I have the formulas for Body Density and Body fa
They are as follows:
1. Body Density (BD): 1.109380 - [0.0008267 x (SKF)] + [0.0000016
(SKF)2] - (0.0002574 x Age)
2. Body Fat (in percent): [(4.95/Db) - 4.5] x 100
(From Jackson & Pollock (1978))...