Forum Discussion
calculate value based on displayed value
I have the following formula in cell C18 =C16*C19/10 Cell C16 contains the value 2.37 and Cell C19 contains the value 80. Cell C18 displays the value as 19.0, but the actual value is 18.9...
There are a few options, one option is to use ROUND( x, 1) to force the value to round to 1 decimal place. you can use that in cell C18 = ROUND(C16*C19/10 , 1) and then the VALUE in C18 will actually be 19.0 or you can use it in the "next" cell like =E18/ ROUND(C18,1) * 100
