Agentic demo automation is here.
Meet Lily
This interactive demo was created free with Storylane in 2 minutes. Create your own demo
This interactive demo was created free with Storylane in 2 minutes. Create your own demo
Start free

How to Create a Custom Formula in Microsoft Excel

‍

‍

It is very easy to create a custom formula in Microsoft Excel. Here’s a quick guide on how to do it:

‍

  1. Inside your Microsoft Excel worksheet, select the cell where you wish to run the custom formula.
  2. After that, type an 'Equals' (=) sign to indicate that your succeeding input is a formula.
  3. Type the name of the function you wish to use and then select it from the suggested results.
  4. Next, enter the cell reference or cell range and then end the formula with a closing parenthesis.
  5. Input an operator or separator if you want to add another condition.
  6. Subsequently, type the name of the function and then select it from the recommended matches.
  7. Add the cell range or cell reference you wish to use as the argument.
  8. Once done, insert a closing parenthesis to end the formula. If you want to add more condition, simply repeat the same series of steps.
  9. Finally, press the 'Enter' or 'Return' key to run the newly created formula and view the results.
Similar Articles

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel

Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Build Killer Demos in 2 Minutes
Chrome Extension Icon
Try our Chrome extension
DOWNLOAD

Desktop app for macOS
DOWNLOAD
Backed by
Y combinator
AICPA SOC
GDPR
Products
Guided DemosSandbox DemosDemo Hub
Featured
Account RevealPersonalizationIntegrations
Solutions
EnterpriseGrowth & Demand
MarketingProduct MarketingSalesPresales
Resources
BlogTutorialsHelp DocsWhat’s NewDemo DundiesPlaybooks
Company
CareersPricingPartnersContactTrust CenterDemo Abuse
Customers
Demo ShowcaseCase Studies
Built in San Francisco Bay Area - ©2025 Storylane
Backed by
Y combinator
AICPA SOC
GDPR
Privacy PolicyTerms & Conditions
X Corp (formerly Twitter)LinkedIn
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it