# Multiple IF criteria formula

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

### Multiple If Criteria Formula

Rate this:
(3/5 from 1 vote)

 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 on

 Replies - Displaying 1 to 1 of 1 Order Replies By: Most Recent | Chronological | Highest Rated
 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