Excel Format / Formula Question

[AggieJ16]

Hi all,

I have been trying to figure out how to do this and can't seem to or find a resource online that addresses this.

I have one summary sheet with five additional sheets focused on monthly commission.

The summary sheet needs to have the total commission with TWO decimal places. So I changed the format to 'Accounting'. The problem is though, some of the monthly commissions were rounded up and some were not. I want them to stay AS IS. I don't want to round the remaining or go back and change the other monthly commissions from their current formatting.

I noticed that if the summary cell is set to accounting, it will apply that to each individual sheet, so sheets that were rounded end up not getting rounded...

Is there a way that I can have a Summary cell with two additional decimal places that simply adds the values I have for each monthly amount without changing how the values are displayed?

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional. Thanks!

No help to be offered, please, until the OP complies with this request.

[AliGW]

Once you have amended your title, will you please attach a sample Excel workbook?

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.