Excel automatically rounding my calculated number

[lholden]

Hi all,

I'm having a slight issue with rounding on my excel sheet at the moment.

I have two cells which contain separate calculations - I11 and C14. I11 is a sum total of 3 other cells - =I8+I9+I10 (872) - while C14 is a simple average - both I11/3 and AVERAGE(I8:I10) have been tested (290.67). Then, cell C15 is what should be a simple multiplication - =C14*63.

However, C15 is returning a rounded number every time - $18,312.00 instead of 18,312.21. I've tried everything I can think of or readily find at a cursory glance on the internet (which is admittedly small), but nothing seems to work. The only thing that has worked so far is hard coding the numbers (i.e. C15 = 290.67*63), but that is undesirable as this calculation needs to be performed for a number of different clients.

Any help you can offer is greatly appreciated!

 

[lholden]

Never mind, I was able to figure it out. I had to set C14 = ROUND(I11/3,2) which allowed to multiplication to happen properly, giving me 18,312.21!