Relative Content

Tag Archive for excelexcel-formulaformula

Excel trailing zeros

Given this formula in excel =TEXT(ROUND(R22,C13),”0.00″)
How do I make so that “0.00” is calculated automatically depending on the number of digits inputted in C13.

Excel formula with dynamic inputs & dynamic outputs

I have two table ranges in excel. One will have the conditions and equivalent formulas to be used for those conditions. And in other table, I have conditions and their input values that should be given to the formulas. I need to substitute the inputs with the relevant condition formula and get the output. How to do it directly in MS excel without using VBA