I'm trying to import a file into Numbers that I built in Excel that uses a lot of calculations where I would hit command+enter in Excel to calculate it as an array which was signified by putting { } around the entire equation. Is there a way I can do this in Numbers?
MacBook Pro with Retina display, OS X Yosemite (10.10.3)
Hi cowboysnut,
Numbers does not support array formulas. Maybe there this a Numbers way to achieve the same outcome.
Please tell us your overall aim. More information will lead to a solution 🙂.
Regards,
Ian.
Thank you for your input. I basically have a table that I'm looking for a quick check if the full table has been filled out. I'm using it as a chart to track when things are done and I'd like a binary output for if it has been completed. The equation that worked in Excel is {=IF(SUM(ISBLANK(C8:I15)×1)=0,1,0)}. I know I can accomplish this by doing a table of the same size full of isblank functions linking back to the original C8:I15 table, but that seems overly clunky. I'm finding ways to fix some of my other issues, but some other things look like Numbers does not have a good solution, like hyperlinked cells to jump from one sheet to another.
Hi cowboysnut,
You could do this easily with conditional highlighting and you would have a simple visual as to what is missing.
Menu>Format>Conditional Highlighting>
Do this for one of your cells, select the rest and combine rules.
quinn
cowboysnut wrote:
I basically have a table that I'm looking for a quick check if the full table has been filled out. I'm using it as a chart to track when things are done and I'd like a binary output for if it has been completed.
If I understand you correctly, using COUNTIF can give you a 1 if the range has no blanks, and 0 if it has one blank or more.
=IF(COUNTIF(C8:I15,"")=0,1,0)
SG
Excellent! That's a better solution than I first had anyway. Now if there was a way to hyperlink between sheets I'd really be in business, but this solved the question I asked for this thread, so thanks for your help everyone!
Array Calc
