You are here: HomeExcelTutorials

# IF function for multiple values

## IF function for multiple values

Price: FREE

I have an IF Function to return a particular value - like below
=IF(E7="perspex - bolts","L/E","")
But I need it to also look in column J and return L/E if the criteria = High End, so logically I thought something like this
=IF(E7="perspex - bolts","L/E","")+=IF(J7="High - End","L/E","")ORJ7="Mid - range","L/E","")
Obviously it isn;t this
So I only want it to return the "L/E" if the criteria in columns E and J = "Perspex-bolts" AND "High-End" or "Mid-range
What formula would I need to achieve this?

Visit publisher's web-site: IF function for multiple values

Category and Tags: ExcelTutorials :

## Related Tutorials

### Vlookup multiple identical values

Free: Yes
Tags: Excel ›

This is my first post, I hope I don't come across as too much of a novice.
Is it possible to Vlookup multiple identical values? or should I be using another function?
i.e. If I want to return the value in column 5 where ever ABC123 appears in the lookup table?

### 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

### Multiple values with Vlookup (arrays)

Free: Yes
Tags: Excel ›

I have a small issue with an array function that I am trying to use in an excel sheet. I have one worksheet which contains monthly employee pension details, the first column being the employee pension number, across different years.
In the lookup sheet, the user should be able to enter the employee number and see the details generated . I am able to only obtain the first line with my array function, for April 2005 which is the first date. The second month onwards, the array function does not work. I am attaching a sample file. Could someone let me know what is wrong with my formula ? Slightly

### Looking up multiple values and returning one corresponding value

Free: Yes
Tags: Excel ›

I am wondering if it is possible to lookup multiple values using the vlookup function and return one corresponding value? More specifically, I want to lookup a part number and machine number and then return a value associated with each of the two criteria. I have tried using nested vlookup functions, but have yet to get anything to work properly.

### vlookup - multiple values

Free: Yes
Tags: Excel › Functions

Is there any advanced function to vlookup to extract multiple data if the required item is repeated in the data?

## 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
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

### Multi-thread Simulation in PHP

Free: Yes
Tags: PHP › Excel Classes Performance

This class can emulate the execution of program threads using separate HTTP requests to the same script. It establishes an HTTP connection to the same Web server to execute the same PHP script. It sends a request passing the name a function to execute and an argument to be passed to that function. The requested script executes some code that detects the thread execution request and calls the specified function. When the thread request script ends, the return values of the called function is returned as a serialized string. The calling script can execute other tasks while the thread script runs. The results may be collected later when the thread script ends.

### 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.