Operating Margin
Returns the operating profit margin for a company, calculated as operating income divided by total revenue. This metric shows how efficiently a company manages its operating costs.
Supported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Notes
- Value is returned as a decimal (0.30 = 30%)
- Based on trailing twelve months (TTM) data
- Also known as operating profit margin or EBIT margin
Syntax
=OperatingMargin(Symbol)Returns
number
Operating margin as a decimal (e.g., 0.30 = 30%)
Examples
=OperatingMargin("AAPL")=OperatingMargin("MSFT")=OperatingMargin("GOOGL")=OperatingMargin(A1)When to Use
- Analyzing operational efficiency
- Comparing companies within same industry
- Screening for operationally efficient stocks
- Understanding core business profitability
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need net profit margin | ProfitMargin() |
| Need gross margin | GrossMargin() |
| Need EBITDA margin | ebitda_margins() |
| Need pre-tax margin | PreTaxProfitMargin() |
Common Issues & FAQ
Why am I getting "NA"?
Check that:
- Symbol is valid and actively traded
- Company has reported financials
- Symbol format is correct
Is this TTM or quarterly?
This returns trailing twelve months (TTM) operating margin.
Related Formulas
More MarketXLS Key Ratios formulas you can use in the same worksheet:
- P/E Ratio (TTM)
- Pay Date (On Demand)
- Payout Ratio
- PE High In Last 5 Years
- PE Low In Last 5 Years
- PEG Ratio (TTM)
- Price to Book Ratio (TTM)
- Price To Cashflow
See OperatingMargin used in a complete workbook: Airline Stocks Screener Excel: Summer 2026 Peak Travel Operating Metrics Dashboard
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?