How to automatic % calculation on the dollar amount

G

geloader0

Board Regular
Joined
Dec 21, 2022
Messages
52
Office Version
  1. 2016
Platform
  1. Windows
Hi, Good day,

I need to set automatic % calculation on the dollar amount between amount of collection over the GPR right after the percent collection section. How to do it in formula and VBA? Thank you so much for your help :)
 

Attachments

  • 1.JPG
    1.JPG
    30.7 KB · Views: 20

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
You must log in or register to reply here.

Similar threads

A
  • Solved
Excel to automatically calculate the Electricity Bill
Replies
1
Views
620
etaf
etaf
J
  • Question Question
Excel to automatically calculate the GST
Replies
2
Views
304
Fluff
Fluff
L
  • Solved
VBA Replace All '/' in a sheet, except for formulas
Replies
4
Views
114
MARK858
MARK858
Jyggalag
  • Question Question
Debt payment in Excel?
Replies
1
Views
216
Jyggalag
Jyggalag
J
  • Question Question
Calculation based on value in table based on date range
Replies
0
Views
256
jsand
J

Forum statistics

Threads
1,223,885
Messages
6,175,178
Members
452,615
Latest member
bogeys2birdies

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top