Excel Automation & Custom Solutions
121+ Professional Functions
Purpose-built formulas that work just like Excel's built-in functions
exl.AI.Classify
Other
Classify text into one of the provided categories using AI. Requires Anthropic API key.
Text (string), Categories (string)
=exl.AI.Classify(A1, A1)
exl.AI.Extract
Other
Extract specific data from unstructured text using AI (e.g., company name, dollar amount, date). Requires Anthropic API key.
Text (string), WhatToExtract (string)
=exl.AI.Extract(A1, A1)
exl.AI.FormulaExplain
Other
Explain what an Excel formula does in plain English. Requires Anthropic API key.
Formula (string)
=exl.AI.FormulaExplain(A1)
exl.AI.FormulaWrite
Other
Generate an Excel formula from a plain English description. Requires Anthropic API key.
Description (string)
=exl.AI.FormulaWrite(A1)
exl.AI.Match
Other
Find the best fuzzy match for a value in a range using AI (e.g., "IBM Corp" matches "International Business Machines"). Requires Anthropic API key.
LookupValue (string), LookupRange (object)
=exl.AI.Match(A1, A1)
exl.AI.Summarize
Other
Summarize text or a range of text values into a concise summary using AI. Requires Anthropic API key.
TextOrRange (object), MaxWords (object)
=exl.AI.Summarize(A1, A1)
exl.AI.Translate
Other
Translate text to a target language using AI. Requires Anthropic API key.
Text (string), TargetLanguage (string)
=exl.AI.Translate(A1, A1)
exl_Currency_Convert
Other
Convert currency using manual exchange rate: Amount × Rate
Amount (double), ExchangeRate (double), RoundTo (object) [optional]
=exl_Currency_Convert(100, 100, A1)
exl_Currency_Convert_Live
Other
Convert currency using live exchange rates (requires internet, cached 15 min)
Amount (double), FromCurrency (string), ToCurrency (string), RoundTo (object) [optional]
=exl_Currency_Convert_Live(100, A1, A1, ...)
exl_Currency_Rate
Other
Get current exchange rate between two currencies (requires internet, cached 15 min)
FromCurrency (string), ToCurrency (string)
=exl_Currency_Rate(A1, A1)
exl_States_Lookup
Other
Look up US state: supply name to get abbreviation, or abbreviation to get name. Optionally include capital.
State_Or_Abbreviation (object), Include_Capital (object)
=exl_States_Lookup(A1, A1)
exl_States_Lookup_Headers
Other
Returns column headers for State.Lookup: [State/Abbreviation, Capital] based on input type
Input_Type (object)
=exl_States_Lookup_Headers(A1)
exl_Summary_By_Period
Other
Aggregate date-value data into period summaries with business day averages
DataRange (object), Period (string)
=exl_Summary_By_Period(A1, A1)
exl_Summary_By_Period_Advanced
Other
Aggregate with full control over work schedule and gap day counting
DataRange (object), Period (string), WeekStartDay (object), WorkDayCount (double), CountGapDays (bool)
=exl_Summary_By_Period_Advanced(A1, A1, A1, ...)
exl_Summary_By_Period_Custom
Other
Aggregate with custom work schedule (start day + day count)
DataRange (object), Period (string), WeekStartDay (object), WorkDayCount (double)
=exl_Summary_By_Period_Custom(A1, A1, A1, ...)
exl_Summary_By_Period_Preset
Other
Aggregate with preset work schedule ("MonFri", "MonSat", "SunThu", "AllDays")
DataRange (object), Period (string), WorkSchedule (string)
=exl_Summary_By_Period_Preset(A1, A1, A1)
exl_Terms_Discount_Percent
Other
Extract discount percentage from terms (e.g., "2/10 Net 30" returns 0.02 for 2%)
Terms (object)
=exl_Terms_Discount_Percent(A1)
exl_Terms_Due_Date
Other
Calculate due date from terms. Return_Type: "Payment" (net due), "Discount" (early discount date)
Return_Type (string), InvoiceDate (object), Terms (object), Holidays (object) [optional], EndOfMonth (object) [optional], AdjustWeekends (double) [optional]
=exl_Terms_Due_Date(A1, A1, A1, ...)
exl_Terms_Mail_By
Other
Calculate when to mail payment to arrive by due date (subtracts business days for mail transit)
DueDate (object), MailDays (double) [optional], Holidays (object) [optional], AdjustWeekends (double) [optional]
=exl_Terms_Mail_By(A1, 100, A1, ...)
exl_Text_Change_Case
Other
Convert text case. Case_Type: "Upper", "Lower", "Title", "Proper", "Sentence" (default: "Proper")
Text (object), Case_Type (object) [optional]
=exl_Text_Change_Case(A1, A1)
exl_Text_Clean_Whitespace
Other
Remove extra whitespace (trim, collapse multiple spaces to single)
Text (object)
=exl_Text_Clean_Whitespace(A1)
exl_Text_Count_Characters
Other
Count characters in text with options for spaces, line breaks, and character type filtering
Text (object), Include_Spaces (object) [optional], Include_LineBreaks (object) [optional], Count_Type (object) [optional]
=exl_Text_Count_Characters(A1, A1, A1, ...)
exl_Text_Count_Words
Other
Count words in text
Text (object)
=exl_Text_Count_Words(A1)
exl_Text_Extract_Digits
Other
Extract digits only from text (e.g., "ABC-123" returns "123")
Text (object)
=exl_Text_Extract_Digits(A1)
exl_Text_Extract_Letters
Other
Extract letters only from text (e.g., "ABC-123" returns "ABC")
Text (object), Include_Spaces (object) [optional]
=exl_Text_Extract_Letters(A1, A1)
exl_Text_Extract_URL
Other
Extract URL(s) from text
Text (object), Return_All (object) [optional], Delimiter (object) [optional]
=exl_Text_Extract_URL(A1, A1, A1)
exl_Text_Get_Word
Other
Get Nth word from text (1=first, -1=last)
Text (object), WordNumber (double)
=exl_Text_Get_Word(A1, 100)
exl_Text_Legal_Format
Other
Convert number to legal format: fifty-five (55) or fifty-five and five tenths (55.5)
Number (double)
=exl_Text_Legal_Format(100)
exl_Text_Readable
Other
Convert database field names to readable text ("ItemCode" -> "Item Code", "Value_Under12Mos" -> "Value Under 12 Mos")
Text (object), Output_Case (object) [optional]
=exl_Text_Readable(A1, A1)
exl_Text_Remove_From_String
Other
Remove all occurrences of a substring from text
OriginalStringValue (object), StringToRemove (object), IgnoreCase (object) [optional]
=exl_Text_Remove_From_String(A1, A1, A1)
exl_Text_Reverse
Other
Reverse a text string (e.g., "Hello" becomes "olleH")
Text (object)
=exl_Text_Reverse(A1)
exl_Text_Split
Other
Split text by delimiter and return Nth part (1=first, -1=last)
Text (object), Delimiter (string), PartNumber (double)
=exl_Text_Split(A1, A1, 100)
exl_Text_Split_Name
Other
Split name into First, Middle, Last, Suffix, Credentials. Return_Type: "All", "First", "Middle", "Last", "Suffix", "Credentials", "Headers"
Name_Or_Range (object), Return_Type (object) [optional]
=exl_Text_Split_Name(A1, A1)
exl_Barcode
Barcode Operations
Calculate, validate, or format barcodes ("UPC-A", "EAN-13", "EAN-8", "I2of5")
Number (string), Type (object) [optional], Return_Type (object) [optional], Return_Formatted (object) [optional]
=exl_Barcode(A1, A1, A1, ...)
exl_Cartons_Full
Carton & Shipping
Calculate full cartons and partial quantities: returns analysis array or individual value based on Return_Type
Units_Ordered (double), Case_Pack (double), Allow_Partial (bool), Allow_Overship (bool), Return_Type (object)
=exl_Cartons_Full(100, 100, TRUE, ...)
exl_Cartons_Pallets_Needed
Carton & Shipping
Calculate number of pallets needed for total cartons (rounds up)
Total_Cartons (double), Cartons_Per_Pallet (double)
=exl_Cartons_Pallets_Needed(100, 100)
exl_Cartons_Qty_Per_Pallet
Carton & Shipping
Calculate cartons per pallet based on dimensions and height limit
Pallet_Length (double), Pallet_Width (double), Carton_Length (double), Carton_Width (double), Carton_Height (double), Max_Stack_Height (double)
=exl_Cartons_Qty_Per_Pallet(100, 100, 100, ...)
exl_Cartons_Volume
Carton & Shipping
Volume calculations. Return_Type: "CubicFeet" (inches input), "CubicMeters" (cm input)
Length (double), Width (double), Height (double), Return_Type (object) [optional]
=exl_Cartons_Volume(100, 100, 100, ...)
exl_Weight_Chargeable
Carton & Shipping
Calculate chargeable weight: MAX(Actual_Weight, Dimensional_Weight)
Actual_Weight (double), Dimensional_Weight (double)
=exl_Weight_Chargeable(100, 100)
exl_Weight_Dimensional
Carton & Shipping
Calculate dimensional weight: (Length × Width × Height) / Divisor
Length (double), Width (double), Height (double), Divisor (object) [optional]
=exl_Weight_Dimensional(100, 100, 100, ...)
exl_Credit_Cards
Data Utilities
Format credit card number. Formats: 0=1234 5678 9012 3456, 1=1234-5678-9012-3456, 2=1234567890123456
CardNumber (object), Format (double) [optional], MaskDigits (double) [optional]
=exl_Credit_Cards(A1, 100, 100)
exl_Currency_To_Text
Data Utilities
Convert currency amount to English words (for checks). Length pads result to fixed width (e.g., Length=70 gives 'ONE HUNDRED & 00/100*************' to fill a check line).
Amount (double), Length (double) [optional]
=exl_Currency_To_Text(100, 100)
exl_Email_Domain
Data Utilities
Extract domain from email address
Email (object), IncludeWWW (object) [optional], IncludeHTTPS (object) [optional]
=exl_Email_Domain(A1, A1, A1)
exl_Email_Extract_From_Text
Data Utilities
Extract email address(es) from text
Text (object), ReturnAll (object) [optional], Delimiter (object) [optional]
=exl_Email_Extract_From_Text(A1, A1, A1)
exl_Email_Format_or_Validate
Data Utilities
Email utilities. Return_Type: "Clean", "Count", "Validate", "List"
Email_Or_Text (object), Return_Type (object) [optional]
=exl_Email_Format_or_Validate(A1, A1)
exl_Email_Return_Contact
Data Utilities
Parse email to extract contact info. Return_Type: "FirstName", "LastName", "Company", "Full"
Email (object), Return_Type (object) [optional]
=exl_Email_Return_Contact(A1, A1)
exl_Phone_Numbers
Data Utilities
Phone utilities. Return_Type: "Format", "Extension", "Extract", "Validate"
Phone_Or_Text (object), Return_Type (object) [optional], Format (object) [optional], Option (object) [optional], Delimiter (object) [optional]
=exl_Phone_Numbers(A1, A1, A1, ...)
exl_Roman_Numerals_From_Number
Data Utilities
Convert integer to Roman numerals (1-3999)
Number (double)
=exl_Roman_Numerals_From_Number(100)
exl_Roman_Numerials_To_Number
Data Utilities
Convert Roman numerals to integer (I-MMMCMXCIX)
Roman (object)
=exl_Roman_Numerials_To_Number(A1)
exl_SSN
Data Utilities
SSN utilities. Return_Type: "Format", "Validate"
SSN (object), Return_Type (object) [optional], Format (double) [optional]
=exl_SSN(A1, A1, 100)
exl_Zip_Code
Data Utilities
ZIP code utilities. Return_Type: "Format", "Validate"
ZipCode (object), Return_Type (object) [optional], Format (double) [optional]
=exl_Zip_Code(A1, A1, 100)
exl_Aging_Buckets
Date & Time
Configurable aging buckets. Returns value in matching bucket or headers as spill array. Set Return_Type to "H" for headers.
Receipt_Date (object), DollarsOrUnits (object), MonthsInBucket (object), RegularBuckets (object), FinalBucketMonthsPlus (object) [optional], DollarsUnitsOrBoth (object) [optional], Aging_Date (object) [optional], Return_Type (object) [optional]
=exl_Aging_Buckets(A1, A1, A1, ...)
exl_Date_Day_Of_Week
Date & Time
Get day of week (full name, abbreviation, or number)
Date (object), Start_Of_Week (object) [optional], Format (object) [optional]
=exl_Date_Day_Of_Week(A1, A1, A1)
exl_Date_Difference
Date & Time
Calculate the difference between two dates in various units (years, months, weeks, days)
StartDate (object), Format (object) [optional], AsOfDate (object) [optional]
=exl_Date_Difference(A1, A1, A1)
exl_Date_FirstLast_Of_Period
Date & Time
Get first or last day of a period ("Week", "Month", "Quarter", "Year"). Set BusinessDay="TRUE" for business day.
Date (object), Period (object), Position (object), BusinessDay (object) [optional], FiscalStartMonth (object) [optional], Holidays (object) [optional]
=exl_Date_FirstLast_Of_Period(A1, A1, A1, ...)
exl_Date_Quarter
Date & Time
Get fiscal quarter (Q1, 1, First Quarter, or Q1 2025)
Date (object), Fiscal_Start_Month (object) [optional], Format (object) [optional]
=exl_Date_Quarter(A1, A1, A1)
exl_Date_Range_Date_End
Date & Time
Returns end date (center date plus days after)
CenterDate (object), DaysAfter (object)
=exl_Date_Range_Date_End(A1, A1)
exl_Date_Range_Date_Start
Date & Time
Returns start date (center date minus days before)
CenterDate (object), DaysBefore (object)
=exl_Date_Range_Date_Start(A1, A1)
exl_Date_Range_Dates
Date & Time
Returns start and end dates for a range centered on a date (array formula)
CenterDate (object), DaysBefore (object), DaysAfter (object)
=exl_Date_Range_Dates(A1, A1, A1)
exl_Date_Week_Number
Date & Time
Get ISO week number for a date
Date (object), Week_Start_Day (object) [optional]
=exl_Date_Week_Number(A1, A1)
exl_Date_Week_Of
Date & Time
Returns the first day of the week for a given date
Date (object), WeekStartDay (object)
=exl_Date_Week_Of(A1, A1)
exl_Date_Workdays_Add_Subtract
Date & Time
Add workdays to date (excludes weekends and holidays)
StartDate (object), Days (double), Holidays (object) [optional]
=exl_Date_Workdays_Add_Subtract(A1, 100, A1)
exl_Date_Workdays_From_Range
Date & Time
Count business days between start and end dates (excludes weekends and holidays)
StartDate (object), EndDate (object), Holidays (object) [optional]
=exl_Date_Workdays_From_Range(A1, A1, A1)
exl_Date_is_Business_Day
Date & Time
Check if a date is a business day (TRUE/FALSE)
Date (object), Holidays (object) [optional]
=exl_Date_is_Business_Day(A1, A1)
exl_Fin_Asset_Turnover
Finance
Calculate asset turnover: Revenue / Assets. Provide Total_Assets for snapshot, or Beginning_Assets + Ending_Assets to use average.
Revenue (double), Total_Assets (double), Beginning_Assets (object) [optional], Ending_Assets (object) [optional]
=exl_Fin_Asset_Turnover(100, 100, A1, ...)
exl_Fin_Breakeven_Price_Detailed
Finance
Calculate break-even price: (Fixed Costs / Units) + Variable Cost per Unit
Fixed_Costs (double), Variable_Cost_Per_Unit (double), Units (double)
=exl_Fin_Breakeven_Price_Detailed(100, 100, 100)
exl_Fin_Breakeven_Price_For_Profit
Finance
Calculate required price to achieve target profit
Fixed_Costs (double), Variable_Cost_Per_Unit (double), Units (double), Target_Profit (double)
=exl_Fin_Breakeven_Price_For_Profit(100, 100, 100, ...)
exl_Fin_Breakeven_Quantity
Finance
Calculate break-even quantity: Fixed Costs / (Price - Variable Cost)
Fixed_Costs (double), Price_Per_Unit (double), Variable_Cost_Per_Unit (double)
=exl_Fin_Breakeven_Quantity(100, 100, 100)
exl_Fin_Breakeven_Revenue
Finance
Calculate break-even revenue: Fixed Costs / Margin%
Fixed_Costs (double), Margin_Percent (double)
=exl_Fin_Breakeven_Revenue(100, 100)
exl_Fin_Cash_Ratio
Finance
Calculate cash ratio: Cash / Current Liabilities
Cash (double), Current_Liabilities (double)
=exl_Fin_Cash_Ratio(100, 100)
exl_Fin_Contribution_Margin
Finance
Calculate contribution margin: Price - Variable_Cost (dollars) or (Price - Variable_Cost) / Price (percent)
Price (double), Variable_Cost (double), Return_Type (object) [optional]
=exl_Fin_Contribution_Margin(100, 100, A1)
exl_Fin_Contribution_Margin_Unit
Finance
Calculate contribution margin per unit: Price - Variable Cost
Price_Per_Unit (double), Variable_Cost_Per_Unit (double)
=exl_Fin_Contribution_Margin_Unit(100, 100)
exl_Fin_Current_Ratio
Finance
Calculate current ratio: Current Assets / Current Liabilities
Current_Assets (double), Current_Liabilities (double)
=exl_Fin_Current_Ratio(100, 100)
exl_Fin_Days_In_Inventory
Finance
Calculate days inventory outstanding (DIO): 365 / (COGS / Average Inventory)
COGS (double), Average_Inventory (double)
=exl_Fin_Days_In_Inventory(100, 100)
exl_Fin_Days_Sales_Outstanding
Finance
Calculate days sales outstanding (DSO): 365 / (Revenue / Average Receivables)
Revenue (double), Average_Receivables (double)
=exl_Fin_Days_Sales_Outstanding(100, 100)
exl_Fin_Debt_To_Assets
Finance
Calculate debt to assets ratio: Total Debt / Total Assets
Total_Debt (double), Total_Assets (double)
=exl_Fin_Debt_To_Assets(100, 100)
exl_Fin_Debt_To_Equity
Finance
Calculate debt to equity ratio: Total Debt / Total Equity
Total_Debt (double), Total_Equity (double)
=exl_Fin_Debt_To_Equity(100, 100)
exl_Fin_EPS
Finance
Calculate earnings per share (EPS): Net Income / Outstanding Shares
Net_Income (double), Outstanding_Shares (double)
=exl_Fin_EPS(100, 100)
exl_Fin_Equity_Multiplier
Finance
Calculate equity multiplier: Total Assets / Total Equity
Total_Assets (double), Total_Equity (double)
=exl_Fin_Equity_Multiplier(100, 100)
exl_Fin_Interest_Coverage
Finance
Calculate interest coverage ratio: EBIT / Interest Expense
EBIT (double), Interest_Expense (double)
=exl_Fin_Interest_Coverage(100, 100)
exl_Fin_Inventory_Turnover
Finance
Calculate inventory turnover: COGS / Average Inventory
COGS (double), Average_Inventory (double)
=exl_Fin_Inventory_Turnover(100, 100)
exl_Fin_Net_Profit_Margin
Finance
Calculate net profit margin: Net Income / Revenue
Net_Income (double), Revenue (double)
=exl_Fin_Net_Profit_Margin(100, 100)
exl_Fin_Operating_Margin
Finance
Calculate operating margin: Operating Income / Revenue
Operating_Income (double), Revenue (double)
=exl_Fin_Operating_Margin(100, 100)
exl_Fin_Quick_Ratio
Finance
Calculate quick ratio (acid test): (Current Assets - Inventory) / Current Liabilities
Current_Assets (double), Inventory (double), Current_Liabilities (double)
=exl_Fin_Quick_Ratio(100, 100, 100)
exl_Fin_ROA
Finance
Calculate return on assets (ROA): Net Income / Total Assets
Net_Income (double), Total_Assets (double)
=exl_Fin_ROA(100, 100)
exl_Fin_ROE
Finance
Calculate return on equity (ROE): Net Income / Shareholders' Equity
Net_Income (double), Shareholders_Equity (double)
=exl_Fin_ROE(100, 100)
exl_Fin_ROI
Finance
Calculate return on investment (ROI): (Gain - Cost) / Cost
Gain (double), Cost (double)
=exl_Fin_ROI(100, 100)
exl_Fin_Receivables_Turnover
Finance
Calculate receivables turnover: Revenue / Average Receivables
Revenue (double), Average_Receivables (double)
=exl_Fin_Receivables_Turnover(100, 100)
exl_Fin_Working_Capital
Finance
Calculate working capital: Current Assets - Current Liabilities
Current_Assets (double), Current_Liabilities (double)
=exl_Fin_Working_Capital(100, 100)
exl_Pricing_Gross_Profit_Margin
Finance
Calculate gross profit margin: (Revenue - COGS) / Revenue
Revenue (double), COGS (double)
=exl_Pricing_Gross_Profit_Margin(100, 100)
exl_Pricing_Price_To
Finance
Calculate price-to ratio. Return_Type: "Earnings" (P/E), "Book" (P/B)
Return_Type (string), Stock_Price (double), Per_Share_Value (double)
=exl_Pricing_Price_To(A1, 100, 100)
exl_Math_Apply_Percent
Math Functions
Apply percentage to value. Use positive percent to increase, negative to decrease.
Value (double), Percent (double)
=exl_Math_Apply_Percent(100, 100)
exl_Math_Original_Value
Math Functions
Calculate original value from new value and percentage change (reverse calculation)
New_Value (double), Percent_Change (double)
=exl_Math_Original_Value(100, 100)
exl_Math_Percent_Change
Math Functions
Calculate percentage change: (New Value - Old Value) / Old Value
Old_Value (double), New_Value (double)
=exl_Math_Percent_Change(100, 100)
exl_Math_Round_To
Math Functions
Round to nearest multiple (5, 10, 25, etc.) with direction control
Value (double), Multiple (double), Direction (double) [optional]
=exl_Math_Round_To(100, 100, 100)
exl_Math_Sum_Every_Nth_Column
Math Functions
Sum every Nth column in a range (e.g., N=1 sums all, N=2 every other, N=3 every third)
Range (object), N (double), Start_Column (double) [optional]
=exl_Math_Sum_Every_Nth_Column(A1, 100, 100)
exl_Pricing_Convert_MarkupAndMargin
Pricing
Convert between markup and margin. Return_Type: "MarkupToMargin", "MarginToMarkup"
Return_Type (string), Percent (double)
=exl_Pricing_Convert_MarkupAndMargin(A1, 100)
exl_Pricing_Cost_From_Price
Pricing
Calculate cost from price. Return_Type: "Markup", "Margin"
Return_Type (string), Price (double), Percent (double)
=exl_Pricing_Cost_From_Price(A1, 100, 100)
exl_Pricing_Discount_Amount
Pricing
Calculate discount amount: Original Price × Discount%
Original_Price (double), Discount_Percent (double)
=exl_Pricing_Discount_Amount(100, 100)
exl_Pricing_Discount_Percent
Pricing
Calculate discount percentage: (Original - Sale) / Original
Original_Price (double), Sale_Price (double)
=exl_Pricing_Discount_Percent(100, 100)
exl_Pricing_Gross_Profit_Dollars
Pricing
Calculate gross profit in dollars (price minus cost)
Price (double), Cost (double)
=exl_Pricing_Gross_Profit_Dollars(100, 100)
exl_Pricing_Keystone_Price
Pricing
Calculate keystone price (Wholesale Cost × 2)
Wholesale_Cost (double)
=exl_Pricing_Keystone_Price(100)
exl_Pricing_Margin_After_Discount
Pricing
Calculate margin percentage after discount is applied
Original_Margin (double), Discount_Percent (double)
=exl_Pricing_Margin_After_Discount(100, 100)
exl_Pricing_Markdown_Amount
Pricing
Calculate markdown amount: Price × Markdown%
Price (double), Markdown_Percent (double)
=exl_Pricing_Markdown_Amount(100, 100)
exl_Pricing_Markdown_Percent
Pricing
Calculate markdown percentage: (Original - New) / Original
Original_Price (double), New_Price (double)
=exl_Pricing_Markdown_Percent(100, 100)
exl_Pricing_Markup_After_Discount
Pricing
Calculate markup percentage after discount is applied
Cost (double), Original_Price (double), Discount_Percent (double)
=exl_Pricing_Markup_After_Discount(100, 100, 100)
exl_Pricing_Original_Price_From_Sale
Pricing
Calculate original price from sale price and discount%: Sale Price / (1 - Discount%)
Sale_Price (double), Discount_Percent (double)
=exl_Pricing_Original_Price_From_Sale(100, 100)
exl_Pricing_Percent
Pricing
Calculate markup or margin percentage. Return_Type: "Markup", "Margin"
Return_Type (string), Cost (double), Price (double)
=exl_Pricing_Percent(A1, 100, 100)
exl_Pricing_Price_After_Discount
Pricing
Calculate price after discount: Original Price × (1 - Discount%)
Original_Price (double), Discount_Percent (double)
=exl_Pricing_Price_After_Discount(100, 100)
exl_Pricing_Price_From_Cost
Pricing
Calculate price from cost. Return_Type: "Markup", "Margin"
Return_Type (string), Cost (double), Percent (double)
=exl_Pricing_Price_From_Cost(A1, 100, 100)
exl_Pricing_Wholesale_From_Retail
Pricing
Calculate wholesale price: Retail × (1 - Retailer Margin)
Retail_Price (double), Retailer_Margin (double)
=exl_Pricing_Wholesale_From_Retail(100, 100)
exl_Retail_From_Wholesale
Pricing
Calculate retail price: Wholesale / (1 - Desired Margin)
Wholesale_Price (double), Desired_Margin (double)
=exl_Retail_From_Wholesale(100, 100)
exl_Retail_Markup
Pricing
Calculate retail markup. Return_Type: "Initial", "Maintained"
Return_Type (string), Cost (double), Price (double)
=exl_Retail_Markup(A1, 100, 100)
exl_Conversions_Distance
Unit Conversions
Convert distance. Units: 0="m" (default), 1="cm", 2="mm", 3="km", 4="in", 5="ft", 6="yd", 7="mi"
Value (double), From_Unit (object), To_Unit (object)
=exl_Conversions_Distance(100, A1, A1)
exl_Conversions_Fabric_Weight
Unit Conversions
Convert fabric weight. Units: 0="GSM" (default), 1="OzSqYd", 2="OzSqM", 3="GramsSqYd"
Value (double), From_Unit (object), To_Unit (object)
=exl_Conversions_Fabric_Weight(100, A1, A1)
exl_Conversions_Temperature
Unit Conversions
Convert temperature. Units: 0="C" Celsius (default), 1="F" Fahrenheit, 2="K" Kelvin
Value (double), From_Unit (object), To_Unit (object)
=exl_Conversions_Temperature(100, A1, A1)
exl_Conversions_Textile_Linear
Unit Conversions
Convert textile linear measurements. Units: 0="OzSqYd" (default), 1="YardsPerLb", 2="LbsPerYard" (requires fabric width)
Value (double), From_Unit (object), To_Unit (object), Fabric_Width_Inches (double)
=exl_Conversions_Textile_Linear(100, A1, A1, ...)
exl_Conversions_Weight
Unit Conversions
Convert weight. Units: 0="g" (default), 1="kg", 2="mg", 3="oz", 4="lb", 5="ton", 6="tonne"
Value (double), From_Unit (object), To_Unit (object)
=exl_Conversions_Weight(100, A1, A1)