3 Replies Latest reply: Mar 20, 2013 5:14 PM by AGoodNeighbor
AGoodNeighbor Level 1 Level 1

Been trying to find the list of Excel-compatible functions but did not succeed. I would like to use Numbers to edit my Excel files in iPad. I often generate reports by pulling data out from a seperate sheet using Excel functions like CELL, SUBSTITUTE, and REDIRECT. I have not purchased Numbers yet, that is why I would like to know where I find the complete list of Excel-compatible functions or at least know if Numbers support these functions.  Thank you in advance.


Numbers, iOS 6.1.3
Solved by Wayne Contello on Mar 20, 2013 4:50 PM Solved

Numbers does support the function substitute()

 

I did not see the functions cell() and redirect() in the function browser.

 

There is afree function reference here:

iWork '09 Formulas and Functions User Guide

 

which you can use

Reply by Badunit on Mar 20, 2013 5:04 PM Helpful

I am not familiar with REDIRECT nor do I see it in the list of Excel functions. Did you mean INDIRECT?  Numbers has INDIRECT.

 

CELL is not supported but many of the values it returns are available through other functions. Values related to cell color, width, and formatting are not available in Numbers.

All replies

  • Wayne Contello Level 6 Level 6
    expertise.iwork
    iWork

    Numbers does support the function substitute()

     

    I did not see the functions cell() and redirect() in the function browser.

     

    There is afree function reference here:

    iWork '09 Formulas and Functions User Guide

     

    which you can use

  • Badunit Level 6 Level 6
    expertise.itunes
    iTunes

    I am not familiar with REDIRECT nor do I see it in the list of Excel functions. Did you mean INDIRECT?  Numbers has INDIRECT.

     

    CELL is not supported but many of the values it returns are available through other functions. Values related to cell color, width, and formatting are not available in Numbers.

  • AGoodNeighbor Level 1 Level 1

    Thank you. Yes, I meant INDIRECT. I doubled check what I did with CELL and I use only its address attribute, I can change that fairly easily to fit in with Numbers.  SUBSTITUTE Is actually supported.  So, I am good to go with Numbers, and can wait to be able to use Numbers on iPad/iPad Mini. I feel like I am now part of the laptop-to-tablet migration! 

     

    Thank you again for prompt responses. You guys are very helpful!