Hi,
I am creating a spreadsheet of a cost/benefit ratio. The actual ratio is composed of a few mathematical formulas (not Excel formulas) and I figured I could do the formula in Excel. My sheet lists the title of the components in column A and the base values in column B (which should serve as a base calculation).
I can get the mathematical formulas to work as they are just simple addition, multiplication, and division problems. But I would like to round the answers of the results. All I have seen has =ROUND(A1,2) to round. But how do I put my formula (=PRODUCT(B3,B11,B21,B17,B13,B14)/B20) which is specific in order of cells, in the =ROUND function? I have tried =ROUND((B3,B11,B21,B17,B13,B14)/B20,2) but the result yields 0 even though some of the cells have values. Actually, only one cell is blank, B3.
Can anyone help me? I am willing to email my sheets for reference.
Thanks,
Elizabeth
I am creating a spreadsheet of a cost/benefit ratio. The actual ratio is composed of a few mathematical formulas (not Excel formulas) and I figured I could do the formula in Excel. My sheet lists the title of the components in column A and the base values in column B (which should serve as a base calculation).
I can get the mathematical formulas to work as they are just simple addition, multiplication, and division problems. But I would like to round the answers of the results. All I have seen has =ROUND(A1,2) to round. But how do I put my formula (=PRODUCT(B3,B11,B21,B17,B13,B14)/B20) which is specific in order of cells, in the =ROUND function? I have tried =ROUND((B3,B11,B21,B17,B13,B14)/B20,2) but the result yields 0 even though some of the cells have values. Actually, only one cell is blank, B3.
Can anyone help me? I am willing to email my sheets for reference.
Thanks,
Elizabeth