You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

IF function multiple criteria

IF function multiple criteria

Price: FREE

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 :/

Visit publisher's web-site: IF function 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?

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.

Rank Function with Multiple Criteria

Free: Yes
Tags: Excel › Functions

I am trying to Rank 5 different criteria for 28 employees. I am currently ranking each criteria as a separate column within each category; however, I need to roll up all of the rankings to another page and have a Power Ranking per employee. The Power Ranking was working as an AVERAGE function until the percentages of the categories were not an equal 20%.

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!
Features in the latest version 2.2 includes:
Javascript function powered by jQuery
Using ajax technology to load data
Sortable column
Specific column to search
Adjustable data row per page
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
- allow or not allow file download
- next, previous, play, stop function
- download prosses bar
- fullscrenn
- 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
4. Uses Google Ajax call, so no Page load is required
5. Added JQuery to make the code more easy to integrate
6. Smaller layout, so that we can use it as widget.
7. Only HTML & Javascript knowledge required

© 2016 Contact us - Privacy Policy - Terms of use - Add Listing