Log In
Create Account
SlickerTalk
Search Archives
The Leaderboard
The FAQ
Login
Create Account
Search
Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...
RSS Feed
Hosting by DigitalOcean
Support ST on Ko-Fi
Links Only
50 Results
100 Results
250 Results
500 Results
1000 Results
5000 Results
2 Weeks
2 Months
6 Months
1 Year
2 Years
5 Years
All Time
Live
Down to Post
Backboards:
Live
________________
1: Dec 11, 14:43
2: Dec 11, 11:29
3: Dec 11, 07:59
4: Dec 10, 18:15
5: Dec 10, 12:28
6: Dec 10, 09:30
7: Dec 10, 05:59
8: Dec 9, 17:07
9: Dec 9, 13:47
10: Dec 9, 10:33
11: Dec 9, 07:33
12: Dec 8, 17:50
13: Dec 8, 10:32
14: Dec 8, 06:23
15: Dec 7, 16:52
16: Dec 7, 07:17
17: Dec 6, 14:40
18: Dec 6, 10:07
19: Dec 6, 07:32
20: Dec 5, 19:48
Posts: 152
In response to
"
Getting even more fancy...
"
by
Mel Profit
nested if, yes. if(a1="paid", "blah", if(a1="in process", "blah 2", if(a1="submitted", "blah 3"))) -- nm
Posted by
all the boys love OBBR (aka amanda)
Apr 22 '15, 19:12
(No message)
Responses:
Got it. It worked. Mel Points for you. -- nm
-
Mel Profit
Apr 22, 19:17
watch your parentheses. I suck at nested ifs because I always miscount parentheses. also a max of seven ifs is allowed per statement. -- nm
-
all the boys love OBBR
Apr 22, 19:13
4
This. It's actually how I learned the step through trick because I always eff up nested statements. -- nm
-
spamlet
Apr 22, 19:20
2
"step through trick"? what? (I suck so bad at nested if. I always embarrass myself.) -- nm
-
all the boys love OBBR
Apr 22, 19:44
I have another question for you folks but I think my brain is fried and I actually need to use the sheet for it's ultimate purpose. -- nm
-
Mel Profit
Apr 22, 19:42
SQL helped train me for this, -- nm
-
Mel Profit
Apr 22, 19:17
Post a message
top
Replies are disabled on threads older than 7 days.
