Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon.

Pages: 1-

Excel function

Name: Anonymous 2012-04-16 12:19

so im trying to get this function down, but im not to good at it.

lets say im looking at cell S2 - U2. 2 of them will say "OTHER", one will not. how do i tell V2 to copy the one that does not say "OTHER" when i dont know what it will say?

Name: Anonymous 2012-04-16 12:50

Oh dear.

Name: Anonymous 2012-04-16 13:05

Something like =IF(U2=="OTHER",S2,U2)

Name: Anonymous 2012-04-16 13:06

your helpfulness is blowing my mind right now.

Name: op 2012-04-16 13:07

no no. im looking at S2, T2, and U2. there are 3 cells. thats what im tripping up on. i have it all worked out for 2. but the 3rd is what throws that entire formula off.

Name: Anonymous 2012-04-16 13:22

(when (or (str= U2 "OTHER") (str= T2 "OTHER") (str= S2 "OTHER"))
(Copy-seq "OTHER"))

Name: Anonymous 2012-04-16 13:44

uh, im not seeing "when" as a function. and what does the "str" stand for?

Name: Anonymous 2012-04-16 13:45

I like this man >>7

Name: Anonymous 2012-04-16 14:33

What will happen if neither or both are "OTHER"?

Name: Anonymous 2012-04-16 16:29

I was going to answer OP's question, but I got distracted by these dubs >>11

Name: Anonymous 2012-04-16 16:59

Name: Anonymous 2012-04-16 17:13

>>11
teach me your ways, dubs-san

Name: Anonymous 2012-04-17 6:12

read sicp

Name: bampu pantsu 2012-05-29 4:27

bampu pantsu

Excel function

1 Name: Anonymous 2012-04-16 12:19

2 Name: Anonymous 2012-04-16 12:50

3 Name: Anonymous 2012-04-16 13:05

4 Name: Anonymous 2012-04-16 13:06

5 Name: op 2012-04-16 13:07

6 Name: Anonymous 2012-04-16 13:22

7 Name: Anonymous 2012-04-16 13:44

8 Name: Anonymous 2012-04-16 13:45

9 Name: Anonymous 2012-04-16 14:33

10 Name: Anonymous 2012-04-16 16:29

11 Name: Anonymous 2012-04-16 16:59

12 Name: Anonymous 2012-04-16 17:13

13 Name: Anonymous 2012-04-17 6:12

14 Name: bampu pantsu 2012-05-29 4:27