Wauvel

Excel like a finance pro.

← The library

Compatibility function

EXPONDIST

Returns the exponential distribution; replaced by EXPON.DIST.

Rarely usedDifficulty 1400 · AdvancedUsage rank #393 of 520
Practice · 2 questions →

When to use it

The exponential distribution. Replaced by EXPON.DIST.

The shape of it

Syntax
=EXPONDIST(x, lambda, cumulative)

Worked examples

  • Cumulative

    =EXPONDIST(0.2,10,TRUE) → 0.864664717

    Cumulative.

  • Density

    =EXPONDIST(0.2,10,FALSE) → 1.353352832

    Density.

  • Survival

    =1-EXPONDIST(5,0.1,TRUE) → 0.60653066

    Survival past 5.

Worth knowing

  • EXPON.DIST is identical.
  • Lambda is a rate.
  • Memoryless distribution.

Where it goes wrong

  • #NUM! for negative x or non-positive lambda.
  • Flagged by the Compatibility Checker.

Related

FORECASTMODEPERCENTILEQUARTILERANKSTDEV

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.