SheetDecode: Excel Formula Fix

appdevelopsk

Contains ads

About this app

You open a spreadsheet somebody else built, click a cell, and the formula bar fills with something you would need ten minutes and three browser tabs to understand. SheetDecode reads it back to you in seconds.

READ ANY FORMULA
Paste a formula and SheetDecode breaks it into the order it actually runs in, naming what every argument is for — which range is being searched, which is being added, which value is the fallback. Nested functions become an indented outline instead of a wall of brackets.

CATCH THE TRAPS
Some mistakes never show an error, they just return the wrong number. A lookup left on approximate match. Criteria missing its quotation marks. The two ranges of SUMIF in the wrong order. SheetDecode flags the traps that the formula's shape is prone to, before they cost you.

FIX THE RED ERRORS
#REF!, #VALUE!, #N/A, #DIV/0!, #NAME?, #NUM!, #NULL! and #SPILL! — each one explained in plain language, with the causes worth checking first and the fix for every cause. When you have a formula loaded, the errors it tends to produce float to the top.

A REFERENCE THAT ANSWERS THE RIGHT QUESTION
Nearly fifty functions, described for someone reading a formula rather than writing one: what it does, what each argument means, and the one thing people get wrong about it.

BUILT TO BE QUICK
• Works completely offline — nothing you paste leaves your device
• No account, no sign-in, no data collection of what you decode
• Available in 17 languages

SheetDecode is free. A single one-time purchase removes ads — no subscription.

Terms of Use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/

What’s new

Updated for the latest Android release and Google Play billing. Stability and performance improvements.