I currently have two sheets in my workbook. On my "detail" sheet I have a column for a percent of increase and another column that is for "total increase". The percent of increase is formatted as a percent and the total increase is formatted as a currency. My formula in the total increase is simply =sum(l3*s3). My amount in the "total increase" column does not permit decimals, therefore it rounds to the nearest dollar, which is what I want. I also have a summary sheet where I show the total amount from the "total increase" column, this amount is off by $3 and I believe it is due to rounding. When I add the total increase by hand in the detail sheet I get 112146; however, On the summary sheet I just have a fomula of =sum('sheet2'!t3:t51) and the total there is 112143.
Does anyone know of a way that I could fix this somehow so that my numbers correspond?
Thank you!
Does anyone know of a way that I could fix this somehow so that my numbers correspond?
Thank you!