Trying to use IF in a spreadsheet formula to return a value based on 2 other values being met. Trouble is, the 2 values that have to be satisfied can be different. I.E., Value 1 can be constant and Value 2 could have multiple values. An additional Value 1 could have different multiple values. My formula (as follows) works thru the first set but then returns FALSE.
=(IF(A2="ftow",IF(B2="MOB2012","FTOW",IF(A2="Ftow",IF(B2="MOB2013","ftow",IF(A2="Ften",IF(B2="DAS ENET","FIBR",IF(A2="Ften",IF(B2="COW SPL EVT","FIBR",0)))))))))
<COLGROUP><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1938" width=53><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><TBODY>
</TBODY>
=(IF(A2="ftow",IF(B2="MOB2012","FTOW",IF(A2="Ftow",IF(B2="MOB2013","ftow",IF(A2="Ften",IF(B2="DAS ENET","FIBR",IF(A2="Ften",IF(B2="COW SPL EVT","FIBR",0)))))))))
<COLGROUP> <COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1938" width=53><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76> <TBODY> </TBODY> | |||||||||||||||||||||||
<COLGROUP><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1938" width=53><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><TBODY>
</TBODY>