Supported Functions

Excel functions that Numstro can reliably generate

Numstro's AI can generate formulas using a wide range of Excel functions. The list below includes functions that are well-supported and tested. Numstro may also generate other Excel functions depending on your specific use case.

Note: Always test generated formulas in Excel to ensure they work correctly with your data.

Math & Statistical

SUMAdd numbers SUMIFSum with one condition SUMIFSSum with multiple conditions AVERAGECalculate mean AVERAGEIFAverage with one condition AVERAGEIFSAverage with multiple conditions COUNTCount numbers COUNTIFCount with one condition COUNTIFSCount with multiple conditions

Lookup & Reference

VLOOKUPVertical lookup INDEXReturn value by position MATCHFind position of value

Logical

IFConditional logic

Text

LEFTExtract left characters RIGHTExtract right characters LENGet text length CONCATENATEJoin text strings

Math & Rounding

ROUNDRound to decimal places

Functions Not Listed

Numstro may generate formulas using functions not listed above. The AI analyzes your question and data to determine the best function to use. If you need a specific function that's not generating correctly, try rephrasing your question or check our function library for syntax examples.