Tag Info

New answers tagged

0

What exactly are you trying to accomplish? Are you testing for the presence of the Groceries category label before adding the amount into your calculation? Are Category and Amount named collections/ranges? The format for SUMIF is: SUMIF(collection_to_test, "test condition", optional_collection_of_values_to_sum) So assuming Category and Amount are named ...


0

So the Apple thread recommended changing the txt to csv. This didn't work, my file was already csv, properly formated etc. No, changing to txt did the trick. I'm finding it harder and harder to recommend switching from Microsoft to Apple. This sort thing just shouldn't be happening.


0

Double clicking on the error bars will let you change the values (as a formula). I found that after a lot of rage clicking.


0

Try this way: IF(D≥66.6%,"High",IF(D<=33.3%,"Low","Medium"))


0

No - injecting a function looks to be something that isn't easily scriptable. A simple macro might be doable and you could start with these two references: https://developer.apple.com/library/mac/releasenotes/InterapplicationCommunication/RN-JavaScriptForAutomation/index.html This link is the developer documentation on how to connect the script to the ...


0

This works great. You can also simply use this statement: =$cell,cell# This will copy the value of the Cell/cellNumber to the highlighted cell of interest. Changing the value in one, will automatically reflect the changes in the other cell.


1

If you save out the files in a Pages format you will not get the errors. You generally only get those errors when trying to open documents from Microsoft Word or something similar. I am pretty sure there is no way to disable the warning though from the preferences or anything.


0

Having the same problem and don't have a permanent solution. However, if you email the file to yourself and open it from the email, it will open.



Top 50 recent answers are included