Rounding

[Mel Smith]

I have a worksheet that gets 'averages' data from another linked workbook. The cells with the linked data are formatted as number 00.00 (2 decimal places). However when doing cross checks and comparisons with a .csv file these averages are always highlighted as being 'wrong/different' because the actual value may be to 4, 5 or 6 decimal places.

On my excel worksheet, I would like to have the linked data rounded to 2 decimal places. The "feeder" cells on the linked workbook have the formula, for example: =IF(D35=T35,0,E35/(D35-T35))

Can this formula be amended to include rounding to two decimal places?

Mel

 

[12Rev79]

Can you share a sample of your data for us to suggest an approach? Have you tried the Formatting?

 

[Mel Smith]

Hi,

I’ve solved my problem, thanks. I’m using a hidden column and the Round function.

Thanks.

Mel