Windows 10: Mastering Excel Formulas

Hey Excel enthusiasts! In the realm of Microsoft Excel, formulas are the real game-changers. Whether you're a seasoned pro or just getting started, let's dive deep into the world of Excel formulas. Question: What's your go-to Excel formula that has been a total game-changer for your data analysis or spreadsheet tasks? Share your formula, and let's create a knowledge hub for mastering Excel together! Feel free to drop your insights, tips, or even your favorite Excel formula hacks! Let's build a community of Excel wizards. #ExcelMasters #SpreadsheetMagic

:)

 

mobile excel formula

"Worksheet names—In a cell in a worksheet, Excel Mobile accurately displays names that reference worksheets within the same workbook. It removes names that refer to other workbooks, arrays such as ={1;2;3;4}, array formulas, or intersection ranges
from the name list. When Excel Mobile removes a name from the list, it leaves the name in formulas and functions. This causes those formulas to be resolved as "#NAME?" Tabs that are hidden in the workbook are not hidden in Excel Mobile."

http://www.microsoft.com/windowsmobile/en-us/help/more/excel-mobile.mspx

You may want to investigate SoftMaker's PlanMaker:

SoftMaker Office and FlexiPDF: Alternatives to Microsoft Office and Acrobat

Pocket PC Mauritius omnia i900 avnya henriett

 

Request for a End-of-month formula for Mobile Excel and a complete list of supported formulas for Mobile Excel

Hi,

So I just have a couple of questions. They stem from my discovery that certain formulas are not supported by the Excel mobile app and that heading then will cause your spreadsheet not to be editable on your mobile app. Ab example of this is the end-of-month
formula (eomonth()). So my two question are:

What is an alternative way of implementing the end-of-month formula in my spreadsheet so that it can be editable on my mobile office app?

Where can I find a list of formulas that are stored by the Excel mobile app so that this doesn't happen again?

Thank you in advance,

John Panzo

 

Request for a End-of-month formula for Mobile Excel and a complete list of supported formulas for Mobile Excel

Thank you. Yes, I can see the formulas on my phone when I click on the [fx] button in the app. But that a is pretty inconvenient place to look.

The issue is that when I'm preparing a spreadsheet on the Excel Web App, I want to know that I will be able to edit it on my phone. I don't want to have my phone open with the formula sheet open and check between the two to make sure that I am only using
formulas included on the list.

I was wondering if there was a list online that I could have in a separate window or if there could be a warning in the Excel Web App that will indicate whether or not the spreadsheet can be edited on the phone or not so that I can check in advance.

As for the end-of-month formula, I was thinking about it, and I might just use the date() function to push a date ahead one month and then subtract one day. I have yet to test this though.

Thank you for your response @profjulie