Multiple IF criteria formula

Excel Help for Multiple If Criteria Formula in Presenting and Reporting Data

Forum Topic

Multiple If Criteria Formula

Rate this:

(3/5 from 1 vote)

Excel Spreadsheet:

	A	B	C
1			.98
2
3
4
5
6		RS

I am very new to Excel. I have a simple formula that I can't figure out.
This is the formula I entered. I need to know how to enter a formula that if I was to enter text "ACC" into B6, instead of RS, my number in C1 would change to .90 This number will then be a multiplier for another as I make entries going down A column.

=IF(B6="RS",".98","0")

Posted by rjayhart on 30 Oct 2010

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Embed more IF functions Rate this: (3/5 from 1 vote) To provide multiple IF criteria in the same formula, IF function statements can be inserted to replace the default value of the original IF function. This can be done as many times as necessary. The formula should be: =IF(B6="RS",0.98,(IF(B6="ACC",0.9,0))) There are other solutions to simplify this task for many criteria such as CHOOSE, and VLOOKUP on a defined list of matching values.
	Excel Business Forums Administrator
	Posted by Excel Helper on 30 Oct 2010

Displaying page 1 of 1

Find relevant Excel templates and add-ins for Multiple IF criteria formula in the Excel Business Solutions Directory