Hello Everyone,
I have two columns that I will be looking at. The first has a number (15.0101-15.1201) the second has names (google, Facebook twitter). I need to make an formula that can look at the second column and if it is google and less than 15.0501 write the word sunk. If the second column is google and greater than 15.0501 then I need it to say forecast. The tricky part comes when I need to to be able to change if column 2 is one of the other choices. For example if column 2 is Facebook then I need it to say sunk when its less than 15.0701. I have about 10 company names but figure if anyone could help me I could finish the formula.
<tbody>
</tbody>
I have two columns that I will be looking at. The first has a number (15.0101-15.1201) the second has names (google, Facebook twitter). I need to make an formula that can look at the second column and if it is google and less than 15.0501 write the word sunk. If the second column is google and greater than 15.0501 then I need it to say forecast. The tricky part comes when I need to to be able to change if column 2 is one of the other choices. For example if column 2 is Facebook then I need it to say sunk when its less than 15.0701. I have about 10 company names but figure if anyone could help me I could finish the formula.
Release | Company | answer I need |
17.0201 | Sunk | |
17.0601 | Sunk | |
17.0501 | Forecast | |
<tbody>
</tbody>