| Home > Forum Home > Presenting and Reporting Data > Multiple IF criteria formula > Embed more IF functions | Share |
Embed more IF functions
Excel Help for Embed More If Functions in Presenting and Reporting Data
| Forum Topic | Login |
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 | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Embed more IF functions in the Excel Business Solutions Directory |