Tag Info

New answers tagged

0

Select the chart. Then Double click on the Bar you want to change. Go to the Fomat Panel. Use the Styles Tab to change the colour of the individual Bar


1

CSV are simple text file where the data are only separated by comas and new lines. There is no concept of sheets therefore Numbers need to create a csv for each sheet.


0

I was trying to do the same thing to represent X seconds in a time format. =CONCATENATE(A0,"s")+"0s" which A0 is seconds


1

Your dates might not be recognized as dates by Numbers. In my case, Numbers does not offer dd/mm/yyyy as one of the standard date format and I have to define a custom format for that pattern. (Not sure, if that applies in your case: The date must be entered according to your locale settings - I can set "dd/mm/yyyy" as the date format, but I have to enter ...


0

Numbers 09 has the SUMIFS function, which operates the same as in Excel. Numbers 08 does not appear to have it, but it has SUMIF. You should still be able to do what you are trying by combining two logical statements. Without using the function, you could also build a new column by multiplying values by a logical statement. For example: =A3 + A4 × ...


0

This may or may not be what you are after. This Assumes you know which cells you will be referencing. And remember this is only an example.. IF(A2<TODAY(),D2,INDEX(D,COUNTA(D) + 1)) Using the IF function. IF(if-expression,if-true,if-false) First Compare date value in A2 with Todays date TODAY() as the if-expression A2<TODAY() We use the ...


1

I'm not 100% clear what you're asking to do since you haven't posted any of the contents of the sheet, but you can use the INDEX, ROWS and COLUMNS formulas to get what you want. INDEX() will return the contents of a cell within a certain range of cells, and you can use rows() to count the number of rows and columns() to count the number of columns, depending ...



Top 50 recent answers are included