New answers tagged

2

Assuming you have a normal Numbers Date/Time 2/11/2016 12:00:00 AM, then a simple IF() statement can be used combined with the HOUR function. =IF( HOUR ( A2 ) < 12, "Good Morning", "Good Afternoon") To add more than just 2 options, nest your IF statement. =IF(HOUR(A3) < 5,"Early",IF(HOUR(A3) < 12,"Morning",IF(HOUR(A3) < ...


6

A workaround is to create a column with formulas like "=-1 * A1", then copy and "Paste Formula Results" (⇧⌘V). But I'm sure there are better solutions.


3

It would be awkward, might not be worth the time, but you would need to program this in automator using numbers hooks for automation / accessibility. That way you could make a service to swap the sign of whatever is selected. Short term, you'd manually change each or set up a function to calculate the negative of the selection and then paste the values over ...


0

Another way of doing this without having to convert the text to number: Use the COUNTIF() function. This way, you don’t even have to convert your "x" to a 1 either: =COUNTIF(E3:E130, "x") This counts all the "x"'s in the column. Same as summing up a bunch of 1's. The SUM() function is not preferred for your situation. Suppose one of the numbers becomes ...


0

In practice, you could sum each column and then sum just the the sum row. That way, you can delete the sum of the column to be skipped when needed and it should be clear about which of the columns is ignored. A more general solution will be tricky since it's programming in conditional values or conditional functions that are much harder to maintain, debug ...


2

If the cells are in text format, they won't be counted. Check they are a number format cell first. EDIT I have tried it myself, when you find and replace, the cell is not automatically updated to a number cell. If you manually type in the number 1, it automatically gets changed to a number format.


0

Although one cannot style individual characters in a formula, one feature of Apple Numbers is the canvas. One can take advantage of this by adding tables and text objects anywhere. The above screen shot uses a static (as the OP's "Invoice terms" text is hard coded in their formula example, it is assumed static) text field placed next to the table (a ...


2

The OP does not specify how TRUE or FALSE are represented in the cell, but as was stated in another answer, using text is rule will work. Text is TRUE add formatting Text is FALSE add other formatting This works for the result of a formula returning the text TRUE or FALSE. If one is using numbers for Booleans, i.e.: 0 or not 0 then use a number rule. ...


1

A boolean in Numbers seems to be represented internally as a String already. Setting "text is TRUE" and "text is FALSE" worked for me.


1

Note that in Persian language the floating point sign is represented with ,. So the problem can be solved by entering the number as ۱,۲۳ or 1,23. In the first form when you want to enter the floating point sign, switch the keyboard layout to English then insert ‍, and then switch it back to Persian and insert the remaining fraction part.


0

Try using the DATEDIF(start-date,end-date,calc-method) divided by 7 to determine number of weeks. For example: DATEDIF returns the number of days between to dates. Dividing that by 7 should result in the number of weeks. This can be rounded as desired and calculated against. From the Formula reference: The DATEDIF function returns the number of ...



Top 50 recent answers are included