OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

IF THEN OR

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
KC4HW
General User
General User


Joined: 01 Jul 2012
Posts: 9

PostPosted: Sun Jul 01, 2012 9:03 am    Post subject: IF THEN OR Reply with quote

I am trying to come up with a function that will evaluate a particular cell and return a THEN result OR another result.

Here is a sample of the data

KZ5MS
SM4GFL
K4AA

so I would like to count the number of characters for each line and THEN place the following information in a cell such as <call:6> for KZ4MS OR <call:7> for SM4GFL OR <call:4> for K4AA

I have 4 thousand calls to sort through of various lenghts.

Can someone help?

Thanks

Jim Johnson
Back to top
View user's profile Send private message
scsisys
OOo Advocate
OOo Advocate


Joined: 17 Dec 2009
Posts: 248

PostPosted: Sun Jul 01, 2012 10:01 am    Post subject: Reply with quote

KC4Hw...

Try the following.....

="Call: "&LEN(A1)

scsisys
(fyi.....my dad was W4EQR; died 05-22-01)
_________________
OO 3.2.1
Win XP /SP3
Back to top
View user's profile Send private message
KC4HW
General User
General User


Joined: 01 Jul 2012
Posts: 9

PostPosted: Sun Jul 01, 2012 10:28 am    Post subject: Reply with quote

Thanks for the help.

Almost got it. I need to include the < and > symbols in the label as well. I got the first one to show but having difficulty with the closing symbol.

right now it is showing

<CALL:6

here's is what I have

="<CALL:"&LEN(B5)

so you have any suggestion here.

Thanks for the help again!

Jim

BTW I checked your Dad's Call in my log of about 40,000 contacts over the last 20 years. Unfortunately I did have a contact with him in that time. Ham Radio is still a fascinating hobby. I got licensed in 1978 and have had a great time DXing, Contesting and just rag chewing--still very active.
Back to top
View user's profile Send private message
karolus
OOo Advocate
OOo Advocate


Joined: 22 Jun 2011
Posts: 210

PostPosted: Sun Jul 01, 2012 10:43 am    Post subject: Reply with quote

Hallo

its obvious:

Code:
="<CALL:"&LEN(B5)  &">"


Karo
Back to top
View user's profile Send private message
KC4HW
General User
General User


Joined: 01 Jul 2012
Posts: 9

PostPosted: Sun Jul 01, 2012 10:43 am    Post subject: Reply with quote

Sorry, I missed typed, I did not have a contact with your Dad.

Jim/KC4HW
Back to top
View user's profile Send private message
KC4HW
General User
General User


Joined: 01 Jul 2012
Posts: 9

PostPosted: Sun Jul 01, 2012 11:01 am    Post subject: Reply with quote

It appears so! Thanks for your input.

Both of the people helped me out.

Best Regards

Jim Johnson
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group