SOLVED
Filtering out negative values
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
BillyL14
8 - Asteroid
‎07-10-2020
01:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I have a list of numbers and want to filter out negative values?
What kind of formula would I need for that?
It looks like this. ie. want to filter out the line with -88 and -9. I tried an if function with the operator [column],"02 but couldn't get it to work
Column A
2
77
-88
454
3
-9
Solved! Go to Solution.
Labels:
- Labels:
- Error Message
3 REPLIES 3
‎07-10-2020
01:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sorry formula tried looked like if [column A]<"0" but I didn't know how to finish
LordNeilLord
15 - Aurora
‎07-10-2020
01:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎07-10-2020
01:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I actually just realised that after I posted!
