Phone Toll Formulas

wolfegirl04

New member
Local time
Yesterday, 18:34
Joined
Mar 19, 2004
Messages
7
I had two formulas for working with phone tolls. I moved offices a while back and can not find the disk I burned them to, and I cant remember them.

One of the formulas was like this: If the cell contains and or equals target number than put “incoming” (and/or if not than “outgoing”) in this (a different) cell.

I also had a formula that if the phone numbers came in 3 columns i.e. area code in one column, prefix in a second column and the last four digits in a third column, would combine all the numbers in one cell.

Thank you for your assistance
 
Howdy. Regarding the first, can you post a simple example?

Re: second question, you can use the concatenate symbol (&), if you want dashes

=A2&"-"&B2&"-"&C2

if no dashes needed, then

=A2&B2&C2
________
PLYMOUTH SUPERBIRD
 
Last edited:
Thank you. A sample of the first would be


If the target number 555-669-4569 is in the dialed number column then the call is lets say incoming, and the formula would display "INCOMING" in the direction column. If there is a different number from the target number in the dialed column then the formula would put "OUTGOING" in the direction column. I hope that makes more sense. Thank you for the help.
 

Attachments

Last edited:
For some reason, when I click on the link to downlaod, I get a message stating that it is an invalid attachment link.
________
Ford Prodigy Specifications
 
Last edited:
Yes, I downloaded. Am looking at the file now.

I made a dynamic named range for column A, TargetNo

=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A)-1,1)

Then in C2, I put this formula and copied down:

=IF(ISNA(MATCH($B2,TargetNo,FALSE)),"incoming",B2)

This might get you started.
________
DIGITAL VAPORIZER
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom