Need help with decimal place output using IMPRODUCT formula.

Sorry nt IMPRODUCT, rather the IMDIV...I am using the IMDIV formula and getting 14 decimal places in the output cell. I need to limit to 2 decimal places. I have tried using the "format cells" function and setting the decimal places to 2 and have tried this with all possible methods, ie...number, custom, scientific, etc...but no matter what I do, the output cell will not reflect my changes. I also tried to format the cell before entering the formula and this made no difference. Please help.

all you are doing is changing how the number is displayed, not its actual value. try using =round("value",2)

then you can format it to 2 decimals

can you try these..

cell formatting #,##0.00
or
trunc(improduct,2)
or
round(improduct,2)

The Excel functions that return complex numbers actually return strings -- there is no way to format them or round them (other than using other formulas).

Why are you doing complex arithmetic?

to shg...Trying to create a spreadsheet whereby users would enter data in certain labeled cells (heart catheterization hemodynamic data) and then the spreadsheet would carry out the hemodynamic calculations (cardiac output etc) based on the formulas I have entered. I have been able to get everything to work except the output of the IMDIV formula.

Why does that requires complex arithmetic? Can you post a workbook, and a link that describes the calculation you're performing if the workbook doesn't make it clear?

@sergiob can you try this just to experiment if it will round to 2..

your formula =IMPRODUCT(IMDIV(B6,(IMPRODUCT(G8,B14)))) say is in cell A1

in cell say B1 =COMPLEX(ROUND(IMREAL(A1),2),ROUND(IMAGINARY(A1),2))

if this will work maybe we can integrate the two formula.

...i stop here if doesn't work.

thanks.