Fix broken Excel or Google Sheets formulas by Jesse AustFix broken Excel or Google Sheets formulas by Jesse Aust
Fix broken Excel or Google Sheets formulasJesse Aust
Cover image for Fix broken Excel or Google Sheets formulas
A lookup that quietly returns the wrong row is worse than one that errors. I find and fix the formulas that are wrong, not just the ones showing #N/A.
What you send: the workbook (or a copy with sample data), up to 5 broken formulas, and what each one is supposed to produce.
What you get back: the fixed file, a note beside every changed formula saying what was wrong, and a short tab explaining how the sheet works.
How it's checked: totals recalculated against your source numbers before and after, and hardcoded values that should be formulas flagged.
Out of scope: building a new reporting system, macros that touch other files without your OK.
One revision: anything that misses the agreed rules gets fixed. New rules are a new quote.
Bigger file or more pages? Send the counts and I'll quote a fixed price.
Starting at$105
Duration2 days
Tags
Clean Spreadsheets
Google Sheets
Microsoft Excel
Excel Formulas
VLOOKUP
Service provided by
Jesse Aust Centralia, USA
Fix broken Excel or Google Sheets formulasJesse Aust
Starting at$105
Duration2 days
Tags
Clean Spreadsheets
Google Sheets
Microsoft Excel
Excel Formulas
VLOOKUP
Cover image for Fix broken Excel or Google Sheets formulas
A lookup that quietly returns the wrong row is worse than one that errors. I find and fix the formulas that are wrong, not just the ones showing #N/A.
What you send: the workbook (or a copy with sample data), up to 5 broken formulas, and what each one is supposed to produce.
What you get back: the fixed file, a note beside every changed formula saying what was wrong, and a short tab explaining how the sheet works.
How it's checked: totals recalculated against your source numbers before and after, and hardcoded values that should be formulas flagged.
Out of scope: building a new reporting system, macros that touch other files without your OK.
One revision: anything that misses the agreed rules gets fixed. New rules are a new quote.
Bigger file or more pages? Send the counts and I'll quote a fixed price.
$105