Uso un foglio Excel su iPad è ho la necessità inserendo nella colonna E il codice che mi riporta sulla stessa riga nella colonna B del testo. Faccio un esempio, se metto nella colonna E il codice A, nella colonna B deve riportarmi la scritta Entrata in contante. In base al codice deve riportarmi del testo. Non posso usare il cercavert perché in alcuni casi riporto del testo che non sono legati a un codice è di conseguenza questo cancellerebbe la formula. Esiste la possibilità di ottenere questo risultato?

Critical feature of excel to audit/ understand calculations made by others...

This idea really belongs to the PC version, but it is made necessary by capacity limitations in the mobile app.
I leave lots of complex formulas around, rather than replacing them with values, because I am thus able to retroactively implement improvements!
My idea would be to block old data from recalculation, thus avoiding processor load but allowing them to be reactivated should changes be desirable.

When typing formulas in the desktop versions of excel, you get hints as to what arguments are expected. This feature doesn’t exist on the iOS versions, and I think it would be a great quality of life improvement from having to press the (i) instead to get more information as to the arguments expected.

Microsoft for mobile devices should have same capabilities as Microsoft for PC.... I don't understand why its not available now!!!!

More convenient for customer, it should have all functions as on PC or MC also on IPAD, e.g. data validation list, etc.

I have to switch to open PC when I need to use those function

I need to have the analysis tool pak for chromebook for my college courses. I paid for a year of office 365 and expect it should have the same features as it does for a PC or MAC. I paid the same price as those users would and I expect the same features to be available to me.

Add an r-squared value for graphs

Meiner Meinung nach ist es sinnvoll, wenn auch die mobile Version von Excel den Umgang mit Formularsteuerelementen erlernen würde. Zumindest sollten Kontrollkästchen die in der Desktopversion erstellt, verknüpft und formatiert wurden auch in der mobilen Version an- und abwählbar sein.

Hi sir, one function is not working good:
=if(a1>=90, put in B cell “A”,0) but the error is #NAME WHEN I WORK THIS OPTION IN computer it works

I have an Excel template that I would like to use Ink/Drawing to add a signature. Once signed I'm looking for a formula that would then recognize when drawing has been used over a cell so I can create a completion checklist recognizing when the users have signed the docs / tabs in the document.

Add Name Box to ios version so that cells can be named

We need show formel on ipad app in excel