# calculator

1. ### Sports Carnival Scoring

I am hoping to make a scoring sheet for a primary school sports carnival. My goal is for it to look something like this: First Second Third Fourth Race 1 Race 2 and so on... First = 20 points, Second = 15 points, Third = 10 points, Fourth = 5 points. I am...
2. ### EMI Projection calculator needed

Hi I am trying to make a EMI calculator with the PMT formula Lets say I have the following variables A1= Loan Amount B1= Duration C1= Rate of Interest I need to make a table with the projections based on the following parameters 1) Let say there is a loan of Rs 1,000,000 and the EMI for a...
3. ### % calculations doesn't seem accurate

Hello I seem to have an issue getting accurate calculations when i use %. I'm trying to get a loan calculator but for some reason the "monthly payment" isn't the same as I have on my actual loan. It's always off by a small margin. For example i have 2 loans loan 1 = € 10.000 at 3,95% intrest...
4. ### Distance & Time Calculator (Chandoo)

Hi All, Hoping to get some help, I'm using the distance and time calculator, that is supplied on the chandoo website, I have my API for bing and everything is working 100% when I save things locally, I have it integrated into a excel project calculator for projects. Which basically calculates...
5. ### Tax Calculator

Hi, I'm trying to create a tax calculator in Excel. The calculator would calculate tax based on a 'purchase price' and the %'age rate on each band. Any assistance would be gratefully appreciated. Below is an image of the draft I have created.
6. ### Will a kind soul help to provide a vba solution to press a button (e.g 3) in Microsoft calculator without using sendkeys?

Hi all, Will a kind soul help to provide a vba solution to press a button (e.g 3) in Microsoft calculator without using sendkeys?
7. ### Blended Fee Calculator

Hi Im trying to build a calculator that calculates a blended fee based on the constraints below. For example, if X client has \$10 million to invest - his fee would be:? <tbody> <colgroup><col><col><col></colgroup><tbody> Investable Assets \$ 10,000,000.00 Blended Fee From To Rate...
8. ### VBA run-time error 91, variable not set

I'm now getting run-time error 91 with it highlighting my variavle rng1 as not being set. The code worked previously but now on re-opening the file isn't working. If someone could please let me know what I need to alter here in my code I'd greatly appreciate it. Dim x As Integer Dim y As...
9. ### Data validation list

Hi All, I created a calculator with data validation and then created a formula to calculate qty of t-shirts by color by size using SUMIFS, but when I change the data in the calculator, the data leaves the previous cells calculation, For example, if I have 5 green t's in small, the result is in...
10. ### How to implement an online calculator into an excel workbook

Hello I want to implement an online calculator from a webside into an excel document. https://icmphilly.com/ortho-applications/prosthetic-joint-infection-pji-risk-calculator/ I want to be able to set those parameters in the excel document and get the points and the risk from the calculator...
11. ### Surveys Needed Calculator

Good Day! I wanted to make a calculator to determine the number of perfect surveys needed to reach the target. Please see details below: Current score: 96.77% # of Surveys: 31 (30 satisfied / 1 dissatisfied) Goal: 98% Appreciate any help ?
12. ### Plotting curves or shapes?

Hello everyone! I've posted before, then later deleted my account, but now I'm in need of your expertise again. I have a calculator called "Chutecalc1" written by a gentleman who used to be in one of my model rocket forums. Anyway, this calculator calculates the shape required for a...
13. ### Macro for calculating taxes

I'm having a lot of trouble starting this sub in vba. Here is what I have already, but I'm not sure if I'm taking to right angle. Sub tax()Dim income As Double Dim tax As Double income = InputBox("enter your income") If income >= 200000 Then tax = ".35/income" else if income End Sub Assume...
14. ### Calculate shipping cost by entering weight

I have an excel worksheet which has 3 sheets in total. This is the 2nd one. And this is the 1st I want a formula that will automatically take data from 2nd sheet (when I enter a weight in "Enter Weight LB" cell) and paste it on "Shipping Cost" cell by Zone of course. "Your Zone" cell is...
15. ### VBA to open files to import into calculator

Hello all, my first time here and beginning VBA user. I designed a calculator which compiles and interpretes the results of 9 different sets of output from image analysis software. I always name the 8 output files identical: 1 to 9 (excel workbooks). To start the calculator I use a messagebox...
16. ### Spinner Buttons in Google Docs

HI, ive made a one sheet document that i want to publish on google docs and use as a basic calculator when im on the move. trouble is when i open it in google docs all the spinner buttons do not appear..
17. ### gpa calculator

hi, i was wondering if someone could help me with calculating my gpa for 5 subjects. I am searching for a online gpa calculator and also a gpa to percentage converter. Please help me with the steps to use the calculator, if any.
18. ### Recovery Drawdown Calculator

Hello All. I'm trying to figure out how to make a drawdown recovery calculator. I've come up with the formatting, outline of the calculator, and I've got an idea of what some of the formulas might be. Trouble is I can't see how to enter the formulas into the spreadsheet properly. I have a...
19. ### Exporting data to other columns in the same work book

Hello, I'm not sure how to explain my question, as I'm not familiar with the Excel Lingo, but here goes. I have created a calculator for position sizing of stocks. It's very basic. Just a few inputs and the other data are calculated - brilliant. Now, as time passes, I'd like to keep a log of...
20. ### Half-life calculator WITH redosing

I'm trying to make an elimination half-life calculator (for medications and such, can use the basic one without redosing for radioactive decay too). The formula for a basic half-life calculator is easy enough, but when you want to add redosing, its hard. The thought behind was to be able to...

### 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.

### Which adblocker are you using?

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

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