Today, we added the ability to select and insert functions from a list of more than 300 supported functions (thanks to OpenOffice.org). You can select from a wide range of functions – Mathematical, Financial, Statistical, Logical, Date & Time, Engineering, Text, Information, and Spreadsheet functions.

As shown in the image above, select your target cell and click the Insert Function on the toolbar (fx) to bring up the Function dialog. Here you can select the function you wish to insert. You can also filter functions by the different categories like Statistical, Logical, Mathematical, etc. Hover your mouse over the function to see its syntax below. Click on the function to insert it in to the cell. Type in the parameters and hit enter / tab to save the formula to the cell. Nested functions can easily be created. For detailed description, click on the Reference link in the function dialog. This will bring up the detailed reference for the functions.

Apart from the above we have fixed couple of issues. More information on our What’s New page.

As always, try it out and send us your feedback and suggestions. We really appreciate them.

  1. hans43_nutwood

    Dear RameshBrilliant! But when I do this in my sheets the result is always 0! I only use MAX at the moment. What do I do wrong?Kind regards
    Hans

  2. hans43_nutwood

    Dear RameshBrilliant! But when I do this in my sheets the result is always 0! I only use MAX at the moment. What do I do wrong?Kind regards
    Hans

  3. Turbodeif

    Really good job! I’m really glad using the fantastic Zoho services!Related to this new ability, next step could be the capability to create and implement our customize functions for use as formulas.Thanks for all.

  4. Turbodeif

    Really good job! I’m really glad using the fantastic Zoho services!Related to this new ability, next step could be the capability to create and implement our customize functions for use as formulas.Thanks for all.