Home > Forum Home > Presenting and Reporting Data > Multiple IF criteria formula Share

Multiple IF criteria formula

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


Forum TopicPost Reply Login

Multiple If Criteria Formula

Rate this:
(3/5 from 1 vote)
ConfusedExcel 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 on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Oops
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 on
 Displaying page 1 of 1 

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