Add formula function to Ribbon

On the Home ribbon I would like to add the =Round function in the editing section where the autosum appears. Is there a way to do this? I found where to customize the ribbon, but it doesn't allow me to add this specific function.

This is just for my personal copy of Excel. I was using the Autosum button before for quick access, but it was causing problems with my formulas. Chatted with a friend and discovered that I need to use =ROUND(x*y,2) instead of =SUM(x*y). This fixed my problem, but now it will take a few more keystrokes or clicks to enter in whereas before I was simply clicking the Autosum button. I hope that makes sense.

Lol, I couldn't think of a better name

Thanks for your reply! I think I can follow most of these steps, they make sense. However, I don't know how to put a macro into a VBE. Steps please?

Followed all of the steps in the link you provided. Was able to create the macro and add the new button to my ribbon perfectly. Thank you for that!

Only problem is that it does not work as a formula now. Perhaps it will help if I explain exactly what I am trying to do.

I am creating customer invoices. So column F is price per unit, G is quantity, and H is total (F*G)

For F I enter my cost for the unit, and multiply by the percentage I want to mark it up. This becomes a problem when rounding is involved and causes H to be wrong sometimes. This is why I need the ROUND formula instead of regular Autosum.

Example:

F11: =SUM(20.35*1.15)=23.40
G11: 2
H11: =SUM(F11*G11)=46.81 Obviously this is incorrect as it should be 46.80

When I enter F11 as =ROUND(20.35*1.15,2) then everything tallies correctly.

The problem with this is it requires much more typing on my part instead of the quick autosum button that I was using before. This is why I am trying to add the Round function to the Ribbon

I am sorry it took me so long to get back here; it has been a hectic week.
I am going to attempt to attach a sample document with the formulas I am talking about.
The first line shows it when I use the AutoSum button.
I like the use of this button because it is quick and simple, however it is producing a rounding issue for my invoices.
The second line shows the same amount but calculated with the =Round function instead.
This produces the correct value, but requires several more keystrokes on my part, which will really slow me down when doing invoices.
I would like to be able to have a button identical to the AutoSum button in the Ribbon, but have it be the =Round formula instead of =Sum.

Because this is a customer invoice that I print off and hand to the person. They might have 10 parts that each cost me a different amount of money. I then take that part and mark it up, in this case 15%. This is why it is $20.35 (my cost) times 1.15 (which equals their cost with the 15% markup). Then column G is how many were used. In this case there were two of whatever part used in their repair, making the end total for that particular part $46.80. Just like your receipt would read if you bought 5 of the same item from a store.

I do not maintain a regular inventory list for most parts because there are thousands of parts that could be used on all of the different equipment we service. Therefore we order what is needed on a case by case basis. Since this is how we order there are occasional price fluctuations from our wholesalers that would make maintaining a set price sheet more time consuming than its worth.

To make bookkeeping easier, I like to leave our cost hidden in the formula so that I can quickly open my version of the document and see exactly how much we paid for said part, and how much we marked up, on any given invoice . Rather than having to dig though the file cabinet to find old purchasing receipts.

Does that make more sense?

Well thanks for trying anyways!

Maybe someone over there will have a way to help.

I will try this when I get back home. Thanks!

Originally Posted by Gregor y

for what it's worth I believe you want to do this instead:

1. open your workbook
2. File(tab)>Options(list entry)>Advanced(list entry)
3. scroll most of the way down to the "When calculating this workbook" section
4. select your workbook
5. check the box that says "Set precision as displayed"
6. it'll whine at you, click ok, then ok again to close the options dialogue box

now you should be able to:

1. click cell F4
2. type: =20.35*1.15
3. tab key
4. 2
5. tab key
6. type =
7. left-click F11
8. type *
9. left-click H11
10. enter/tab key(your preference, enter should take you to the next row though)