I have a convoluted issue and I hope I can describe it clear. I have a form
(frmCloseout) that is fed from a query (qryLink). In the design mode of the
form, the "detail" area shows one line. When you run the report, all the
information for that contract comes in and has multiple lines on the report
view. Now I need to do some calculations to show up in the detail area of
the form, but need to have my query recognize a specific cost code/cost type
(the first two boxes in the detail line), and if this cost code/cost type is
true, then perform a calculation that incl...multiple "IF" statements in function
I'm trying to build a vacation tracker but i don't know VB. Is there a way
to get muliple if statements using the function built into excel? This is
what I would ike to use:
If (e) <= (365) Then
(f)= "0 Weeks"
if (e) > (365) and <= (730) then
(f) = "1 week"
if (e) > (730) and <= (1825) then
(f) = "2 Weeks"
if (e) > (1825) and <= (3650) then
(f) = "3 Weeks"
If (e) > (3650) Then
(f) = &qu...if statement #9
in col 2 , i have a if statement on col 1.
i want the if statement in a code. Also the no of data on col 1 could
vary. if there are blanks on col 1, i don't want a result on col 2
now after entering the data on col1, i drag the formula in the first
cell on col2 all the way down to the last. Also the formula is open to
all. I fear it may be tampered. In a code it maybe safe, right??
Message posted from http://www.ExcelForum.com/
I'll try to help although your English is a little confusing.
If A1 is empty o...LIKE statement in ADO prodices no results
I have a front/end and back/end MS Access databases that I am connecting via
In the f/e I am issuing a query containing LIKE statement. The very same
query works fine when issued in the b/e Access mdb.
When placed in f/e VBA code, it does not work, there are no results returned,
but no syntax error. I have a strong suspicion that the wildcard * may not
work properly with ADO?
My query is something like this:
"Select field1, field2 from tbl where field2 LIKE '*blah*'"
after successful DAO connection in VBA.
There are no results. But there are results when the same que...If statement in report
I am trying to put in an calculated field in my report. I have a field
called "qualified" and in the field I would like it to total the number of
"yes" fields. I have tried =iff([qualified] = "yes",count"yes") but that
doesn't work. I think I am close. Does anyone have any suggestions.
Are you actually trying to do this in the report or in the reports query? Is
the field [qualified] actually a text field, or a Yes/No field?
1. If you are doing this in a query, and the [qualified] field is actually
a Yes/No data type, then it will have to...Using a COUNTIF statement with an AND operator
I'm using Excel 2003 so I hope I'm not limited here.
We are performing a space usage survey and I need to compile the data
results. Each location has 70 entries over the course of 10 days. I have a
column for "group work" where the value is either 1 or 0. I have another
column for # of people observed in a particular office. What I'm trying to do
is the following:
Get a count of instances where "# of people" = 1 and "group work" = 0
I'm doing a lot of countif statements, but I don't see how to do a countif
with an and operato...If statement in a Macro
Can a Macro have an if statement in it?
I need to remove highlighting in a column if the value in a certain cell
equals a certain value. Is this possible to do in a Macro?
if range("a1")=4 then do your trick
"Dave" <Dave@discussions.microsoft.com> wrote in message
> Can a Macro have an if statement in it?
> I need to remove highlighting in a column if the value in a certain cell
> equals a certain value. Is this possible to do in a ...Option Grp and Field If statement
I apologize. I accidently posted this in the Modules forum first.
I have a form called "frm_Credits". I have an option group called
"Frame_Credit". Within this group are 4 options. They populate the "Credit"
field. I also have a field called "Units". What I need to do is go through
a series of scenarios that could occur and perform an action for each one.
This is what I have for code and I put it after updating the "Units" field
and also after updating the Option Group. After updating either one of these
fields, nothing happens. ...can't download statement from Schwab
I can't connect to Schwab site today to directly download
statement. I called Schwab to reset password and it is
still not working. Error code OFXIE12031 keeps showing.
This is first time I experience this problem.
Heard you the first time. Let it rest for a few hours and see if it still
"fred" <email@example.com> wrote in message
> I can't connect to Schwab site today to directly download
> statement. I called Schwab to reset password and it is
> still not working. Error code OFXIE...Creating a dynamic IF statement
I have data in two sheets. I want to create an IF statement in the second
sheet that has the ability to scan the first sheet for a value. If it finds a
match to a value in the second sheet, deposit the value into the
corresponding cells of sheet two. My example:
User B 12/10
User C 12/15
In this example, I will have the IF statement in column B of Sheet 2. I want
the IF statement to scan column A in sheet 1 for matches to column A of sheet
2. If it finds a match, place the corresponding value in column B (in this
case, it wou...Xpath equivalent to select in statement in sql
What I am trying to do is filter on some attributes and I could have a list of values, so instead of doing where attribute = value or attribute = value, I am wondering if there is something equivalent to the IN statement in sql, so attribute in (value1, value2) etc..
...Useing IF statements to change a cell color
I know this has been beat to death but I just cant seem to figure it out.
This is what I want to do
=IF(94<D8<97,[change cell color to red],[do nothing])
I have tried the conditional formatting but the value in D8 is referenced
from another page in the same worksheet.
How can I get this to work?
It will be a conditional format. A cf wants either a true or false answer. So
for your example this formula should do
which will colour the cell based on your formatting choice when D8 is
between 94 and 97...
Jim Thomli...Conditional Formatting and CountIF Statement
I need to apply shading to cells that have been counted in a countif statement.
It would help if you gave us the condition for the countif
But use that condition in Format > Conditional Formatting
Norman Harker MVP (Excel)
"Kim" <Kim@discussions.microsoft.com> wrote in message
>I need to apply shading to cells that have been counted in a countif
Thanks for helping me Norman.
Here is the coun...Reading Online Statements
I've recently noticed that in several of my investment accounts, after
reading my online statement, the 'account list' page still shows transactions
to be read. In addition, in the acounts themselves, the 'To Do Read online
statments' still show up. All my account information has been properly
downlaoded and the accounts all balance, but I can't easily tell when there
is new information present. When I click on the 'Read online statemnts,
within one of the accounts, I'm taken to the 'Review investment holdings'
page where my only option is to clic...IF Statement 01-17-08
I am trying to run a query that has 4 fields: location, type, year, and
cost. However I need to increase the cost for the year 2007 for 2 types.
The IF statement I entered into the cost field is:
TotalCost:IIF([Type]="C" Or "H" And [Year]=2007,[SumCost]/.9,[SumCost])
The issue I am having is that it is increasing the costs for all types. Is
there a way to fix this or do i need a new query for C and H and then combine
the 2 queries? Thanks for any help you can provide.
Actually, you don't need to do it that way. Create a Where clause for the
query tha...IF statement?
I am compiling a 'build sheet' for a few products. I have part number
in one column, and prices in another (with checkmark boxes near produc
numbers). Im drawing a blank here, but I want to have the price appea
in some box (have yet to determine, but I am going to put all th
prices in a column, to make it easier to total). How would I go abou
linking the check box, to the price? Hope that makes sense. Thank
metalsped's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2282
Vi...Sum if and statement
i am trying to put together a formula that sums a column based on the
information in two other columns. The two columns that need to be evaluated
have Dept name and Customer name. there are approximately 80 rows that need
to be evaluated in each column, and i want the sum to be only of the values
that match the criteria for the Dept & Customer names.
assuming your data is in cells A2:C100, Dept Name is col A, Cust Name is col
B, and value to sum is col C.
Hope this helps.
"Susan" ...NESTED IF STATEMENT
This is a multi-part message in MIME format.
I have to calculate commission on sales tax collected based on the =
1) If sales tax collected is $11.00 or less, then the commission =3D to =
the sales tax collected
2) If sales tax collected is $11.01 - $333.33, then the commission=3D =
3) If sales tax collected is more than $333.33, then commission =3D 3.3% =
of the sales tax collected, with a maximum amount =3D $99...IIF statement 08-23-07
I would like to use an IIF statement to look for the text in field [Type] and
if it is not Voluntary, to show Employer on the report.
I have tried IIF([Type] Not Like "Voluntary","Employer","Voluntary") and all
I get is Employer listed on the report. It changes those that are voluntary
Not sure what I am doing incorrectly.
Check Access HELP on "Like".
Your IIF() expression tells Access to look for EXACTLY "Voluntary" in the
[Type] field. If you meant "Voluntary" SOMEWHERE IN the [Type] field, you'd
ne...If statement referring to a blank cell
I want to put an if statement in code that will say something like
If a1 is blank then
blah blah blah
I can not seem to figure out how to refer to "blank"
If Range(A1").Value = "" Then
MsgBox "blah, blah, blah"
Else: MsgBox "halb, halb, halb"
Gord Dibben Excel MVP
On 16 Mar 2005 15:28:11 -0800, "papa jonah" <firstname.lastname@example.org>
>I want to put an if statement in code that will say something like
>If a1 is blank then
>blah blah blah
&...Double If Statement help
I am trying to create a formula that will look in column "b2" which will be a reference to a month i.e Jan
then if the answer is Jan, then look in column "h2",
to see if it contains a "1" (it will either contain a "1" or nothing). If it does i need it to take the value out of column G2 (which will be a number) and paste it in the cell im typing the formula into to.
Hope This makes sense
any help will be greatly appreciated.
Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Video Library Template Ava...SQL Statement Problem
The following SQL Statement prompts for me to "Enter Parameter Value"
for InstallDate, and I can't figure out why.
If I leave out the Criteria, then it works fine.
Can someone explain?
Criteria: Is Not Null And IIf([Forms]![boxSeats]![PrintOneOrAll]="All
> Field: InstallDate:
> Criteria: Is Not Null And IIf([Forms]![boxSeats]![PrintOneOrAll]="A...If statement help #6
I am trying to write a formula using multiple if statements or some
other method in Excel and I cannot seem to make it work. Here is the
If B9 > 0 then calculate value (E9) using (B9/.8) else
if C9 > 0 then calculate value (E9) using (C9/.9) else
This is an insurance application dealing with coinsurance and
conversion to 100%.
Any ideas would be greatly appreciated.
ekfinch's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28658
View this thread: http://w...Importing a CSV File and using a Conditional Statement and Row delete?
First off, this group is really helpful for us "newbies" attempting
to do some calculations. A big kudo's for your monitoring this group.
I am importing a csv file into excel, and then need to do the
1) If on a row I have values in column A and B, excecute this
2. If #1 does not execute, then I should have values in columns C and
D, and calculate this formula.
When I bring that csv file in, I have many blank rows that I would
like to delete quickly.
1. Use worksheet formula like this,
=IF(AND(NOT(I...downloading bank statements #3
New to ms money.
Money is always one to two days behind on downloaded bank
transactions online at bank still exist, money will not
download to the current date always one or two days behind
Maybe this is the only dates the bank has available to download???!?!?!
"Scott" <email@example.com> wrote in message
> New to ms money.
> Money is always one to two days behind on downloaded bank
> transactions online at bank still exist, money will not
> download to the c...