1. SocomH

    % 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...
  2. C

    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...
  3. J

    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.
  4. A

    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?
  5. P

    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...
  6. Z

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

    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...
  8. M

    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. I want to be able to set those parameters in the excel document and get the points and the risk from the calculator...
  9. G

    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 ?
  10. J

    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...
  11. K

    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...
  12. N

    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...
  13. M

    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...
  14. Z

    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..
  15. N

    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.
  16. John Caines

    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...
  17. C

    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...
  18. J

    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...
  19. T

    Distance Calculator for excel between two citys with kilometer result

    Hello kings of the formula i want to Distance Calculator for excel between two citys like this one
  20. V

    Payslip Calculator Excel

    Hi All, Does anyone know of an Excel Payslip Calculator available to download somewhere? Normally when I want to estimate my next months Payslip based on my Basic and my overtime being 1 month in arrears I use this website: But ideally...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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