Excel Array Formula Series #7: Boolean Logic & Criteria

Roughly I'm looking for an excel solution to show this question:

(if (c2 >= '1') AND (j2 >= '1') then '20' else (if (c2 >= '1') OR (j2 >= '1') then '10' end) end)

c2 & j2 being my two cells.

In English:

If C2 or J2 have any value print 10, if both have a value print 20.

I have 2 columns of data with multiple rows

Column A
Row 1 - EE spouse

Column B
Row 1 - Employee Spouse

I want in Column C Row 1 to have the match formula say True or Yes even though the data is only a close match. I want to use a wildcard so the formula is like this:

in Column C
Row 1 =if(A1=*b1,"yes","no")

I want this comparison to happen row by row in column C, I don't want to conditional format Column A to equal Column B because i import the data from different systems.

I need to make vba macro to check did I finished all procedures for some work. It should be done by Boolean logic, like:

Task 1 (Change date of report): Did u finish task 1? then Boolean question Yes (click) No (click) then Proceed Forward on task 2 Yes (click) No (click)

Task 2 (Did you import data from system): Did u finish task 1? then Boolean question Yes (click) No (click) then Proceed Forward on task 3 Yes (click) No (click) ... and so on up to 9 task BUT

i need not to have strict order of finishing task, like I can finish task 1 and proceed to do task example 5, BUT I need it to show which tasks are not finished

I wrote this below, but I do not know how to do it as I write up
Sub Procedures_of_tasks()
Msg = "Did you do Task 1?"
Ans = MsgBox(Msg, vbYesNo)
If Ans = vbNo Then MsgBox "Do Task 1"
If Ans = vbYes Then MsgBox "Proceed Forward"

End Sub

any tips

I am trying to write a complex evaluation to test specific variables. I've gotten part one to work, but am having issues with part two.

Ultimately, there is also a third calculation that evaluates the first two.

I need to determine if a device passes specific tests, and there are two ways to pass. Each device has two channels. These are based on values A, B, C, and D; and each channel is tested separately.

Using test one, the average of A, B, and C must be equal to or less than 30; but no single value can be greater 35. D must be no greater than 55. Test one applies to both channels, if either channel is out of the reference range, the test is failed.

In Excel, I've used the following expression to make this work:

Quote:

=IF(AND(AVERAGE(A6:C6)

Sorry for the fuzzy heading, but here is my question:

Let's say that I have two columns and I would like to see every row where column A contains an x and/or where column B contains an y.

I would like to use the autofilter for that, but to my knowledge it is not possible I think. If you filter two columns at the same time, there is no OR logic between the columns, only And logic. Which means that when I filter x in column A and y in column B I only see the rows that have x in A and y in B... but I want also to see all rows that contains either an x in A or y in B.

So, the question to you is if this is possible using the autofilter.

The question concerns Excel 2003. I know there are much more possibilities in 2007.

Hi all,

I've got a worksheet with five columns of data. The headings run from a1:e1

The number of rows can be anything up to 200,000 rows (I'm using Excel 2007).

e.g.

a1, b1, c1, d1, e1,
country, netbios name, publisher, display name, version
UK, E826HZD2342342, Adobe, Adobe Reader, 8.1.2,
UK, E826HZD2342342, Adobe, Adobe Reader, 8.1.3,
UK, E826HZD2342342, Adobe, Adobe Reader, 7.0.9,

I want to be able to delete any rows that fit my criteria.

for example
1. If version 8.1.3 exists in any row delete that row.
2. Also delete the row that has a matching 'Netbois Name' to the row that step one deleted.

'8.1.3' could be substitied with any version number. of which there are dozens.

I hope this makes sense.

Thanks alot

Ben

Hi. Brand new to the boards here, and while I've grown familiar with Excel over many years, glancing at some of the threads in here makes me feel overwhelmingly Excel-illiterate, save for basic functions and uses. So please go easy on me with the technical responses. Thanks.

Here goes...

OK, what I'm using an Excel spreadsheet for right now is keeping track of the daily prices of the stocks in my portfolio. As part of this, for each trading day I enter the closing price and have a formula to calculate the percent change over the previous day's close. So in essence, let's say I have 3 columns of data: the date; the closing price; and the percent change (or "delta"). What I want to do is: if the stock closed higher than the previous day, make the text (for that delta) green; if it closed lower, make it red. This'll just make it easier for my eyes to discern trends.

I know about Boolean logic, but only as it pertains to assigning values to cells.
Is there a way to control the formatting of the text in a cell this way, too?

Thanks for your help.

A budget line can be positive or negative (revenues or expenses). Performance against the budget line can be 'better than budget', or 'worse than budget'.

What formula will tell you whether performance is better or worse than budget, and tell you if the position has improved comparing it with performance for the previous period?

The permutations seem endless to me - you run out of nesting 'if' statements long before you run out of possible combinations.

Any ideas?

Hi There,
I hope someone can help me to solve my problem

I have the attached my worksheet (Master database) & LC monitoring workbook.

I'm trying to create a formula in "LC monitoring" that look up for invoice no and invoice amount which match "LC number".

How can I do this?