iworknumbers
IF(AND(B13≤74,B13≥75,B13>90),"0","3, 5")
I'm trying to generate an if statement that outputs either 0 if under 74 or under 3 between 75 – 89 and 5 if over 90. I have been trying the above however I'm getting both 3 and 5 displayed. Could someone help me find the fix?
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 single cell table with no border, in this case) containing the cell with the formula.
The OP's use of the CONCATENATE function is unneeded as the ampersands do the same job. To use CONCATENATE in this case:
=CONCATENATE(Terms,", please pay by...")
Where Terms is the reference to the cell containing the Terms text.
Detailed screenshot:
By using a number for the days, this can be used in a calculation against the Invoice date to determine the date payment is due. But that is a topic for another question. ;)
Without access to the spreadsheet that you've shown, I've attempted to recreate this myself. It appears that there are two things wrong with the spreadsheet above:
The test-array for the countif is of Data Format Automatic. This means that the zeros are not of format Duration and can't be compared by the countif.
To fix this, select the entire array and choose Duration from the Data Format list.
The countif's condition is of format Number whereas the test-array is of format Duration.
To fix this, use the following for the countif cell:
=COUNTIF(G2:G11,">0h 0m")
Best Answer
Try this: