Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
iWork Numbers - how to group data using a formula
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="toMACsh" data-source="post: 1503084" data-attributes="member: 112842"><p>Well sure, by using absolute value. But, I have no experience with Numbers formulas, and this is over my head in Excel too. It's going to have to be some sort of conditional formula, to state the obvious. Like IF 30>A1<60 THEN A2=Group 2 using absolute value for groups to include positive and negative angles. But that's not a Numbers formula, you understand, just a concept.</p><p></p><p>Not much help, but <strong>any</strong> is quite lenient.</p></blockquote><p></p>
[QUOTE="toMACsh, post: 1503084, member: 112842"] Well sure, by using absolute value. But, I have no experience with Numbers formulas, and this is over my head in Excel too. It's going to have to be some sort of conditional formula, to state the obvious. Like IF 30>A1<60 THEN A2=Group 2 using absolute value for groups to include positive and negative angles. But that's not a Numbers formula, you understand, just a concept. Not much help, but [B]any[/B] is quite lenient. [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
iWork Numbers - how to group data using a formula
Top