Answered

Missing options that complete operation

0

I inputted data to run an operation. But there are missing cells (options, missing values etc.). For example:  If I want to do the normality test after entering input, it supposed to show 'Options' and 'Missing Value'. Those two options don't appear.

What should I do?

Comments

2 comments
  • Official comment

    Hello Sundipt,

    The option should have enabled, so I am wondering whether your input data is malformed. Send us your spreadsheet to look at (support@numxl.com)

     

     

    Comment actions Permalink
  • Thank you for sending the spreadsheet. The problem is caused by the RC cells reference style. As a workaround, go to File tab, then Options. In the Option dialog, select the "formula" on the left, and uncheck the R1C1 reference style. (see attachment)

    Our engineers will look into this issue tomorrow, but for now, you should be good.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post