I'm trying to create a formula to deliver three different outputs based on conditions of three columns.
IF a2 = 11 AND d2 = 028 return NI Landline OR
IF a2 = 11 AND c2 = 07 return Mobile OR
IF a2 <>11 return Other Number
It;s necessary to check Col C...