SQLDAXExcelPython
LeaderboardRunLifetime
Dynamic arraysHard30 points

Readable formulas with LET

Using LET, name Products!E2:E41 as price and Products!F2:F41 as cost, then return the average of (price - cost) / price.

Hard questions are part of Lifetime and Pro. Read it here, and unlock running and checking your answer from the plans.

How your answer is tested

Your formula goes in a blank sheet. A value or a spilled range both work.

Show solutionLifetime

Runs in your browser with IronCalc, an open-source spreadsheet engine, so this isn't Microsoft Excel. The questions here were checked against real Excel, but a few functions such as AGGREGATE are not available.

Excel formulaselect text to run only that part
Loading editor…

Press Ctrl+Enter or Run to see the result here.