What is the syntax needed to perform 2 or more IF statements? For example, if in one cell, there are 4 possible entries, and you want to match them to certain values, is it possible? Let's say in cell A1, one can enter the values 1,2,3,or 4. In B1 you want to write an equation that will give you an assigned value for each one. 1=100,2=200,3=300,or 4= 400. How is that done?