Share via

Formula working on laptop however doesn’t work in ipad

Anonymous
2023-05-12T06:47:24+00:00

I am pasting the formula which is used to extract values from a table. This works correctly on the computer however it doesn’t update values when used on the iPad.

=TEXT(IF(AJ32="","",

IF(AND(AA3="",AJ32<>""),"Acft Type?",

IF(AND(AA3=772,AI34="Vref 30"),Data!AQ20,

IF(AND(AA3=772,AI34="Vref 20"),"use QRH",

IF(AND(AA3=772,AI34="Vref 25"),"use QRH",

IF(AA3=773,

IF(AI34="Vref 30",

FORECAST(AJ32,INDEX(Data!AJ2:Data!AJ12,MATCH(AJ32,Data!AI2:Data!AI12,1)):INDEX(Data!AJ2:Data!AJ12,MATCH(AJ32,Data!AI2:Data!AI12,1)+1),

INDEX(Data!AI2:Data!AI12,MATCH(AJ32,Data!AI2:Data!AI12,1)):INDEX(Data!AI2:Data!AI12,MATCH(AJ32,Data!AI2:Data!AI12,1)+1)),

IF(AI34="Vref 25",

FORECAST(AJ32,INDEX(Data!AK2:Data!AK12,MATCH(AJ32,Data!AI2:Data!AI12,1)):INDEX(Data!AK2:Data!AK12,MATCH(AJ32,Data!AI2:Data!AI12,1)+1),

INDEX(Data!AI2:Data!AI12,MATCH(AJ32,Data!AI2:Data!AI12,1)):INDEX(Data!AI2:Data!AI12,MATCH(AJ32,Data!AI2:Data!AI12,1)+1)),

IF(AI34="Vref 20",

FORECAST(AJ32,INDEX(Data!AL2:Data!AL12,MATCH(AJ32,Data!AI2:Data!AI12,1)):INDEX(Data!AL2:Data!AL12,MATCH(AJ32,Data!AI2:Data!AI12,1)+1),

INDEX(Data!AI2:Data!AI12,MATCH(AJ32,Data!AI2:Data!AI12,1)):INDEX(Data!AI2:Data!AI12,MATCH(AJ32,Data!AI2:Data!AI12,1)+1))))))))))),"000 Kt")

Can someone trouble shoot the issue.

Microsoft 365 and Office | Excel | For home | iOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-05-12T14:18:37+00:00

    You’re welcome! I’m glad to hear that you were able to find a workaround for the issue with the formula not updating automatically on your iPad.

    It’s interesting to know that using multiple instances of the INDEX and MATCH functions with the IF function in a single formula seems to be causing the issue with auto-calculation. Thank you for sharing your findings.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-05-12T14:10:17+00:00

    Thanks for troubleshooting my issue, I don't have the options you have mentioned in the ipad app however I have managed a workaround for the issue. I have split the formula in parts, removed some functionality but managed to retain the necessary bits and have a workable solution.

    What seems to be the issue is that when I use more than one instance of INDEX and MATCH functions by using the IF function, in a single formula, the auto calculation stops for that field.

    I will try other combinations when i get the time however right now i have a workable solution.

    Thankyou once again for the help.

    Regards

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-05-12T12:23:06+00:00

    Sorry to hear that the previous suggestions didn’t help. It’s possible that the issue you’re experiencing with the formula not updating automatically on your iPad is due to a setting in the Excel app. Here’s something you can try:

    Open the Excel app on your iPad and then open the workbook that contains the formula. Tap the “File” button (it looks like a folder) in the top-left corner of the screen. Scroll down and tap “Options”. In the “Options” menu, tap “Formulas”. Under “Calculation options”, make sure that “Automatic” is selected. If “Automatic” was not selected, select it and then try using the formula again to see if it updates automatically.

    If “Automatic” was already selected or if selecting it doesn’t help, there could be other factors at play that are causing the formula to behave differently on your iPad compared to your laptop.

    As mentioned earlier, there are some differences between the desktop and mobile versions of Excel, and it’s possible that certain features or functions may not work exactly the same way on both platforms.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-05-12T12:15:20+00:00

    I’m afraid taking the steps you suggested hasn’t worked. The formula works perfectly on the computer app however doesn’t calculate on iPad unless I tap on the formula and then select enter… don’t understand why it would behave differently on the iPad compared to laptop…

    Was this answer helpful?

    0 comments
  5. Anonymous
    2023-05-12T08:51:01+00:00

    Hi Ram

    I'm AnnaThomas and I'd happily help you with your question. In this Forum, we are Microsoft consumers just like yourself.

    It's possible that the issue is related to the version of Excel or the web browser being used on your iPad.

    One possible solution is to check if there is an update for Microsoft Excel in the Apple Store and update it if available. If that doesn’t work, you could try uninstalling and reinstalling Excel on your iPad

    I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

    Best Regards,

    AnnaThomas

    Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

    Was this answer helpful?

    0 comments