You are here: HomeExcelTutorials

# If Function with multiple criteria

## If Function with multiple criteria

Price: FREE

I have am trying to use the If function to deliver a value if 2 criteria are true for 2 different fields. Both contains dates. The first field is blank or not. The 2nd field is filled in. The criteria I am trying to find is if the 1st field is blank and the 2nd field is earlier than today, the function should deliver the value "Overdue" to the third field. How can I use the If function to do this?

Visit publisher's web-site: If Function with multiple criteria

Category and Tags: ExcelTutorials :

## Related Tutorials

### Is there a function that uses multiple criteria in a single column?

Free: Yes
Tags: Excel ›

I'm aware of the SUMIF function that sums up a range based on one criteria. But I'm wondering if there's a function that does the same thing but allows multiple criteria in a SINGLE column.
The SUMIFS function only applies if you have multiple criteria spread across multiple columns *not* in the same single column.
So, any ideas on this?

### IF function multiple criteria

Free: Yes
Tags: Excel ›

statement basically needs to say if cell a1 = "certain phrase" AND B1 is populated then return value in B1.
can't seem to get my IFs and ANDs right :/

### Multiple criteria

Free: Yes
Tags: Excel ›

I want to use sumif function based on multiple criteria,
(my goal is to find SUM of numbers in a column, for the subset I derive by applying criteria to some other columns)
I searched the net and it threw up about array formula.
but I cud not really understand and implement.

### IF function with multiple criteria??

Free: Yes
Tags: Excel ›

I have a problem that to most of you will probably sound ridiculously simple but I am an excel newbie so I still couldn't find a way to do it. Here it is:
I have a column of values. I would like each entry to display a multiple of the value it contains, subject to conditions. In particular, I'll take a single entry as an example:
If it contains a value <1, I would like it to display 0;
If it contains a value between 1 and 2, I would like it to display 2*the value;
If it contains a value >2, I would like it to contain 3* the value.
I found out how to do this subject to a single condition, by using a simple IF function. How can I do this with multiple conditions?
Thanks a lot, any advice is very

### CountA with multiple criteria

Free: Yes
Tags: Excel ›

It's my understanding it's not possible to use the CountA function with multiple criteria so is there any other function that will allow me to count how many cells in a range of cells are equal to 2 different criteria.
For example, I want to find how many entries have the word "Ambient" and where their date value in the next cell is blank.

## Related Applications & Scripts

### Editable Ajax Data Grid With Multiple Color

Free: No
Tags: PHP › Excel Ajax Table and Datagrids

Create a manageable data grid as you want. Ideal for Photo Management, User management, Product management, Project management, Personal portfolio, Album, etc. Multiple color frontend and full function backend The project is aimed to provide a backend for admin to manage data, and a customizable frontend to present data with sorting, paging and searching fuction. All actions are done using ajax, which means fast performance and less traffic!
Using ajax technology to load data
Sortable column
Specific column to search
Ajax pagination
Multiple theme color (silver,green,blue,red)

### Assign multiple shortcuts and events to a function

Free: No
Tags: JavaScript › Excel jQuery

Assign is a jQuery utility plug-in that lets you easily assign multiple keyboard shortcuts and events for specified functions.

### XML Multiple FLV Player + Admin

Free: No
Tags: Flash › Excel Video Players

- read the file via xml driven
- support unlimeted category & category entry
- allow HTML & CCS description
- set flv width & height for each flv
- publish & unpublish each category & category entry
- next, previous, play, stop function
- fullscrenn
CMS FEATURES
- no need any apps for upload files
- no need any apps for create thumbs
- no need to edit, change od delete any items from xml externly
- use cms & make life easier

### PHP Contact Form - Multiple E-Mail

Free: No
Tags: Flash › Excel Emailing Forms

PHP Contact Form, Multiple E-Mail. Flash PHP contact form XML driven, which means you can easily edit settings like company name, emails, description.

### Multiple Distance & Direction Calculator

Free: No
Tags: JavaScript › Excel Calculators

Calculate Distance between Multiple Locations at once using Google MAP API .
Features :
1. Easy to integrate
2. Supports Multiple Locations (more than 2 locations)
3. Auto generate addresses into Textbox when typed