Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
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
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