Hi i have this code
=IF(I2="Q1-2013", "30000000", IF(I2="Q2-2013", "50000000", IF(I2="Q3-2013", "60000000", IF(I2 ="Q4-2013", "55000000", "0") ) ) )
which is they gonna if I2 is "Q1-2013", "Q2-2013", "Q3-2013", and "Q4-2013" then they will add a number it they match else input 0.
however
how will i do if I'm going to create something like this
IF I2="Q1-2013" and A2="UPP" then input 30,000,000 else IF I2="Q2-2013" and A2="UPP" then input 50,000,000 ... etc
else IF I2="Q1-2013" and A2="AII" then input 40,000,000 else IF I2="Q2-2013" and A2="AII" then input 55,000,000 ...
else IF I2="Q1-2013" and A2="AZZ" then input 60,000,000 else IF I2="Q2-2013" and A2="AZZ" then input 85,000,000 ...
something like that please help me
Bookmarks