Hello,
I have a spreadsheet with tens of thousands of formulas like the following. I've split it over multiple lines
for readability.
=IFERROR(IF(K156=0,0,
IF($J156<=AC156,AC$2,
IF($J156<=AD156,AD$2,
IF($J156<=AE156,AE$2,
IF($J156<=AF156,AF$2,
IF($J156<=AG156,AG$2...