multiple conditions

First I am wondering if it is possible to insert text into a new cell if conditional formatting conditions are met, and second if it is possible to require two conditions be met in order to insert the text in a new cell. I am trying to have say column C rows display an "X" if the column A = 10...

I have a spreadsheet where column D contains a 4-8 character code. AAISDJ KDFJS PSDFS PDDSP PASF If the first character is P and the fourth is F I need "Verify" to be put in column H AAISDJ KDFJS PSDFS Verify PDDSP PASF Verify Is this something that can be accomplished?

hello Forum, i would need your help to crack the next problem: i have a column with different numbers and another column with statuses atributed to those numbers ( "ok", canceled", "-") the number in first column can appear multiple times. if they number appear more that one they are grouped...

I have a spreadsheet 'Log' that contains an eomonth formula '=EOMONTH(A4,0)', formatted to custom mmm-yy On a separate sheet I am trying to collate stats on the number of times two conditions are met, one of which is based on the end of month mentioned above. The formula I am using is...

Hello, So I am performing a sum if the value from a cell is equal to any one of the multiple conditions I am providing in separate cells. The formula I currently have works, however it is very bulky because I have three conditions I want to compare to. This is what I have: =IF(OR($'Complete...

I use Excel 2003. Now I have a data sheet in my workbook like this: <TABLE style="WIDTH: 414pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=551 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572"...

Hi, I have a large report, that I want to be able to count the number of vehicles that worked on a specific date. This is how the data is being presented:- A B C 1 Truck: Truck 1 SEMI TRAILER 2 Hauler: abc cartage 3 20/04/2010 12:06:13 PM 8158540 4...

Hi, I've been using a user defined function that I found in the forum below and I would like to manipulate it to make more use out of it and I was wondering if you know how to do this. What I am trying to do is basically count the number of cells that are green in one column only if the...

Hi All, i have a sheet which is being used as a payment advise with subsidies. depending on the product selected, it is either a $value multiplied by the qty or a % of the total value. what i am trying to do as an example: if cell F46 = percent(or sheet2 b6) it needs to multiply by cell...

I was using an If statement, thought it was set up correctly but as I've been entering data it hasn't represented data like i wanted it to. It represents a grade scale for my classes where D7 is my final percentage...

I'm trying to model a somewhat complicated HR process where employees are allowed to voluntarily post to more preferred shifts and depts. I'm starting to thinking excel may not be the most effecient tool, but I can't back down from the challenge! Here's the situations--When there's a need to...

Hi, I have 12 sheets which are named as Jan, Feb, ..... I want to use If condition for a drop down box which consists months from Jan - Dec. Using the vale from drop box I want to fetch data from that particular months sheets.

I have data in my workbook on the "Roster" worksheet, where in a column P I have the session date and in column Q I have the session time. On my "summary" worksheet , I want to have a count of how many rows meet a specific condition in both Column P and Q. I was planning on using the...

Hey everyone. I have this function: =SUMPRODUCT(--($M$6:$M$500=AS$5),--($F$6:$F$500="SD"),$S$6:$S$500) Which works fine - but I need the second condition to actually be if any cell in this range is "SD" or "SD&HD" Then it'll all be dapper. Ta

Hi! I am challenged with a report. I have two worksheets - one for data, one that summarizes it into a report. For the summary, I want certain cells to display the value by looking up today's date in a column and the current time in a row. For example: On the tab "Summary", cell B4 is to...

I would so greatly appreciate any help anyone could give me... I've been working on this for days now! The spreadsheet I'm using has 2 worksheets. On the first worksheet, I would like a line to appear that says "Director Approval Required" whenever any one of these numbers (2280, 2294, 3553...

Help! I am a self-taught Excel beginner. I am using the following equation: =SUMPRODUCT(--(Expenses!$C:$C='Monthly Totals'!$B4),--(Expenses!$F:$F='Monthly Totals'!$C$3),Expenses!$H:$H) In this form it returns a #NUM error. If I modify it to this second version...