Ever had the problem of finding errors in Excel formulas ?
Ever have to a missing double quotes inside an Excel formula ? = """ &A1&"""
Ever have to a missing parenthesis inside a complex Excel formula ?
Then the Excelerator app is for you. Excelerator is intended for heavy users of Microsoft Excel such as business analyst, forecasters, information workers, accountants and CFOs. Anyone who deals with financial reporting.
What is Excelerator and how can it help you?
Excelerator - Excel Formula Fast Fixer is a separate windows application that allows you to quickly analyze and parse Excel formulas!
This program will deconstruct your complex formula and analyze each word. Each word is then validated against the Excel's Visual Basic for Applications (VBA) language and Excel functions.
In example image below, the following formula is parsed.
Furthermore, the Formula Pit Stop area indicates common mistakes such as unpaired parenthesis or double quotes.
Here's another complex formula to analyze
This tool currently is not sold separately, but part of https://clipboardplaintextpowertool.blogspot.com/
Ever have to a missing double quotes inside an Excel formula ? = """ &A1&"""
Ever have to a missing parenthesis inside a complex Excel formula ?
Then the Excelerator app is for you. Excelerator is intended for heavy users of Microsoft Excel such as business analyst, forecasters, information workers, accountants and CFOs. Anyone who deals with financial reporting.
What is Excelerator and how can it help you?
Excelerator - Excel Formula Fast Fixer is a separate windows application that allows you to quickly analyze and parse Excel formulas!
This program will deconstruct your complex formula and analyze each word. Each word is then validated against the Excel's Visual Basic for Applications (VBA) language and Excel functions.
In example image below, the following formula is parsed.
=IFERROR(TRIM(IF(LEN(VLOOKUP(F7, Sheet2!$A$1:$B$10000, 2, FALSE))>0, SUBSTITUTE(VLOOKUP(F7, Sheet2!$A$1:$B$10000, 2, FALSE), "te""st", "1"),"2")), "3")
Parsing the formula will detect and indicate all valid Excel functions and operators as named tokens. Invalid tokens will be identified. A token tree shows syntax indentation structure to easily to ascertain where errors can go wrong, like missing quotes or parenthesis's. Furthermore, the Formula Pit Stop area indicates common mistakes such as unpaired parenthesis or double quotes.
Here's another complex formula to analyze
=MID(SUBSTITUTE(SUBSTITUTE(B4,"/","^",LEN(B4)-LEN(SUBSTITUTE(B4,"/",""))), "/","!",LEN(B4)-LEN(SUBSTITUTE(B4,"/",""))-
This tool currently is not sold separately, but part of https://clipboardplaintextpowertool.blogspot.com/
