Formula Catalogue

Explanations and calculations for formulas and functions most commonly used by Merchandisers and Ecommerce Managers

formula Friday

The best feeling is finding the forumula that fits

Formula Fridays are short reads, spotlighting a single formula that you can start using straight away.

If you are looking for industry specific examples to help support your day to day, you’ve come to the right place.

Discover more
  • IFERROR vs ISERROR blog post feature image

    IFERROR vs ISERROR

  • Improve margin forecasting with goal seek blog post feature image

    Using Goal Seek to Forecast OTB Margin

  • How to use substitute function blog post feature image

    How to use the Substitute Function

  • How to use subtotal function blog post feature image

    Adding Subtotals to your data

  • How to use left and right functions blog post feature image

    How to use the LEFT and RIGHT Functions

  • How to use IF, AND, OR functions blog post feature image

    How to use AND, OR & IF Functions

  • How to create nested IFs in Excel blog post feature image

    How to use nested IFs

  • How to use the IF function blog post feature image

    Getting started with IF statements

A

stock availability

Availability

Average Order Value

average selling price

Average Selling Price

average transaction value

Average Transaction Value

Average Time on Site

B

bounce_rate

Bounce Rate

laptop and espresso cup

C

Cancellation Rate

Churn Rate

Conversion Rate

Customer Lifetime Value

Cart Abandonment Rate

Click Through Rate

Cover

Checkout Abandonment Rate

Closing Stock

Customer Acquisition Cost

Count

Countifs

D

Demand

Discount Rate

Duty

laptop and espresso cup

E

EBITDA

Engagement Rate

Exit Rate

F

Forward Cover

Freight

laptop and espresso cup

Further Markdown

G

Goal Seek

H

laptop and espresso cup

HLOOKUP

I

Intake Margin

IF

INDEX

INDEX MATCH MATCH

M

Markdown Spend

Markdown %

MATCH

N

Net Margin

Net Sales

O

Open Rate

Open To Buy

P

Pos Spend

Pos Cost

Q

QoQ

R

ROAS

ROI

RANK

RANKEQ

S

Sell-Thru Rate

Size Ratio

SUBTOTAL

SUMIFS

U

Units Per Order

Units Per Transaction

V

VAT

VLOOKUP

W

WoW

X Y Z

YoY

open graph logo

Shop Templates

Excel and Me has the examples, templates and formulas you need to analyse and interpret performance data. Helping to easily translate your findings into action focused summaries.


Shop Now

Book a
discovery
call

A discovery call is an opportunity for you to share your business goals, receive FREE expert advice and gain insight on what to do next.


Book Now

Join my
mailing
list

Receive exclusive access to summaries of the content shared on my blog and socials. And the techniques behind my methodology.


Sign Up