Need Help With the Formula PLZ

[KapardhiSarma]

Hi All,


Please see my requirement below. I have 4 Phone numbers - Phone, Phone2, Office and Mobile.


I need a formula to get the Phone number if all the values are different, if phone and phone 2 are equal then phone number, and if these 2 are blank then it should give me office number and if all are blank mobile number. If all the values are blank then the output should be blank.


Please help me out with this.


Thanks,

Kapil

 

[shrivallabha]

What happens if Phone is not available but Phone2 is available? From your statements, I could not work out role for Phone2.

With this considered, try:

[pre]

=IF(A2<>"",A2,IF(C2<>"",C2,IF(D2<>"",D2,"")))
where
Col A --> Phone,
Col B --> Phone2,
Col C --> Office,
Col D --> Mobile

[/pre]

 

[bobhc]

There does not seem to be much use in having phone2 in the formula