LET
Write complex formulas you can actually read.
Why planners need it
Name the pieces of a calculation once, then reuse them. It makes occupancy, shrinkage or Erlang building blocks legible — and faster, since each part computes once.
Syntax
=LET(name1, value1, name2, value2, …, result)
Worked example
Occupancy from raw inputs, readable:
=LET(load, Calls*AHT/Interval, occ, load/Agents, occ) → the offered load is named, then occupancy uses it — no nested mess.
Watch out: Microsoft 365 / Excel 2021 only. Names can’t clash with cell references; define every name before you use it.