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 1, 17:33
2: Dec 1, 11:23
3: Nov 30, 15:54
4: Nov 30, 09:41
5: Nov 29, 16:44
6: Nov 29, 08:01
7: Nov 28, 16:19
8: Nov 28, 09:42
9: Nov 27, 18:07
10: Nov 27, 12:04
11: Nov 27, 08:26
12: Nov 26, 18:06
13: Nov 26, 12:05
14: Nov 26, 08:29
15: Nov 25, 18:33
16: Nov 25, 11:12
17: Nov 25, 07:08
18: Nov 24, 13:17
19: Nov 23, 18:13
20: Nov 23, 06:17
Posts: 157
In response to
"
what's the easiest way in excel to do: if [number] is in [range],1; if not 2? I always forget. thanks. -- nm
"
by
amanda
IF(AND(a1[greater than]1, a1[less than]100)=TRUE, 1, 2) -- nm
Posted by
znufrii
Sep 11 '12, 12:27
(No message)
Post a message
top
Replies are disabled on threads older than 7 days.