Custom Excel Template for Simplifying Checks
Budget: $10 – $30 USD
I need a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts.
For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right.
Key Responsibilities:
- Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work.
- Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division.
Ideal Skills:
- Strong expertise in Excel, especially in creating custom templates.
- Experience with mixed operation formulas.
- Familiarity with Excel's macro and VBA capabilities.
For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right.
Key Responsibilities:
- Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work.
- Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division.
Ideal Skills:
- Strong expertise in Excel, especially in creating custom templates.
- Experience with mixed operation formulas.
- Familiarity with Excel's macro and VBA capabilities.