Welcome to the brand new Therapy? message boards! Find out what’s new or give us your feedback.

XL-brainiacs needed

#

Started by marja (sinner) in Chit-Chat

could somebody please help me with my XL-sheet I need for my job. I need to program stuff with the if-function, for example if that number is in the box, it should be changed into this word

Who can help me? Or do you people need more details?

Posted on Wed, 22 September 2004 at 14:26

You’re viewing replies 1–23 of 23 by 5 people

·

Page: First | Previous | Next | Last

#1

allroy wrote:

Having linux at work I can’t help you at the moment. But as my pc at home is running under Windows I can check that out. If I’m not mistaken it’s something like VB Excel uses for those little functions.
If nobody else helps you out faster I will maybe this evening or tomorrow.
Though I’m not too sure whether you really deserve this. :p

Posted on Wed, 22 September 2004 at 14:33

#2

marja (sinner) wrote:

That would be really nice, and will save me lots of work.

One problem: there are 4 possible contents that have to be converted into a word.

1=boven
2=oog
3=midden
4=grond

so when I type 1, the “boven” should automatically appear

Can you do this?

If one day we’re at the same concert, a nice belgian beer will be yours. Maybe two, that if it works :)

Posted on Wed, 22 September 2004 at 14:42

#3

allroy wrote:

You Belgians are always trying to pollute the rest of the world with your beer, aren’t you? :p

I think it’s no problem at all to let your Excel sheet do that.

Posted on Wed, 22 September 2004 at 14:45

#4

marja (sinner) wrote:

i know it’s not that difficult. i once learned this in school. But I forgot the function that I needed. It was soething with the if, but I forgot how i have to put in more if’s

Posted on Wed, 22 September 2004 at 14:49

#5

OK! wrote:

I think I know how it works…
It’s with if then else end if
I’ve made a program wich fits for your discription and it seems to work, but I noticed I can’t mail it to you. If you want it mail me and I’ll mail you back.

Posted on Wed, 22 September 2004 at 15:27

#6

marja (sinner) wrote:

ok, thank you OK!

I will sent you an email right away

Posted on Wed, 22 September 2004 at 15:31

#7

marja (sinner) wrote:

you got the email?

Don’t know if it worked because I don’t have an emailadress on this site. Let me know?

Posted on Wed, 22 September 2004 at 15:40

#8

OK! wrote:

I’ve got yours
Just send you one back…:)

Posted on Wed, 22 September 2004 at 16:15

#9

hoochalobster (Sarah) Super Moderator wrote:

Ah, trusty old nested IF functions, you gotta love ‘em!

I think what you want to say is this:

=IF(A1=1,”boven”,IF(A1=2,”oog”,IF(A1=3,”midden”,IF(A1=4,”grond”))))

(replacing A1 with whatever cell you’re referencing)

:)

Posted on Wed, 22 September 2004 at 18:47

#10

White Psycho wrote:

If this was C++ that would be so easy, but I’ve never used Excel before like that

Posted on Wed, 22 September 2004 at 19:25

#11

allroy wrote:

Thank god, others were faster. I don’t have to drink Belgian beer. :)

Posted on Thu, 23 September 2004 at 06:46

#12

marja (sinner) wrote:

and even more important, you probably will not have to be nice to since now there’s no reason to team up after the show :p

Posted on Thu, 23 September 2004 at 12:01

#13

allroy wrote:

First of all, don’t be afraid, it’s only a tentative plan to see T? in Brussels.
I’m quite a nice person after T? shows, it’s kind of a relaxed state I’m in then, just like after a satisfying ‘workout’.

Posted on Thu, 23 September 2004 at 12:27

#14

marja (sinner) wrote:

thank you hooch, after changing the formula a bit (put in ; in stead of ,) it just worked great :)

allroy wrote:

First of all, don’t be afraid, it’s only a tentative plan to see T? in Brussels.
I’m quite a nice person after T? shows, it’s kind of a relaxed state I’m in then, just like after a satisfying ‘workout’.

wow, now I can sleep a lot beter for the next months. No cold shivers everytime I think about the conert :p

Posted on Thu, 23 September 2004 at 12:31

#15

marja’s post on Thu, 23 September 2004 at 12:33 was deleted by a moderator

#16

allroy wrote:

Alright then, now I’m going to Brussels. I’ll recognize you as the sleepy one who’s always yawning. :p

Posted on Thu, 23 September 2004 at 12:56

#17

marja (sinner) wrote:

don’t forget the bags under the eyes, I allready have structural bags, so they can only get worse :)

Posted on Thu, 23 September 2004 at 12:57

#18

allroy wrote:

I thought about that, but with botox or excessive use of eyeliner you might get rid of them.

Maybe we could use your snoring during the show as a cello replacement? :p

Posted on Thu, 23 September 2004 at 13:00

#19

marja (sinner) wrote:

I don’t snore I only laugh in my sleep

Posted on Thu, 23 September 2004 at 13:04

#20

allroy wrote:

:D

Weird dreams you must have.

Posted on Thu, 23 September 2004 at 13:07

#21

marja (sinner) wrote:

@ok!: I tried sending you an email today to the ugent adress but it doesn’t work.

Posted on Thu, 23 September 2004 at 14:37

#22

hoochalobster (Sarah) Super Moderator wrote:

marja wrote:

thank you hooch, after changing the formula a bit (put in ; in stead of ,) it just worked great :)

Hmm, must be a slightly different version, commas work for me. No worries anyhoo, am just smug I can remember any Excel at all! :)

Posted on Thu, 23 September 2004 at 20:15

#23

OK! wrote:

I got one mail from you on the ugent mail adres,wich I answered somewhere in the afternoon i think
the other email adres works again (the itne), I can send and receive messages now…

Posted on Thu, 23 September 2004 at 21:38

There are no more replies in this discussion. (Go to the homepage)

to post a reply. Sign in if you’re already a member.

You’re viewing replies 1–23 of 23 by 5 people

·

Page: First | Previous | Next | Last

Other discussions started by marja

Title Replies Started Last post
What’s everybody reading in Chit-Chat 790 14 Oct 2004
by marja		 Today, 09:51
by mr self destruct
dresden dolls in Other Bands & Artists 68 22 Sep 2004
by marja		 10 Oct 2006
by Graeme55?
suikerrock 2006 in Therapy? Live 76 28 Jul 2006
by marja		 9 Aug 2006
by RobbyVDH
life of agony in Other Bands & Artists 136 4 May 2005
by marja		 3 Oct 2005
by Ronald
T? Petrol in Therapy? Live 46 30 Mar 2005
by marja		 25 Sep 2005
by Duca

View all 26 discussions started by marja.