calculator

  1. 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
  2. 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: https://www.uktaxcalculators.co.uk/payslip-calculator.php But ideally...
  3. B

    planetary positions calculator

    I need a MS Excel calculator to find Planetary positions on any given day (past, present or future) as I am a Astrology enthusiast. Can somebody help.
  4. J

    Post Code Calculator UK

    Hi All, I have searched the forum and found some US postcode versions, but i am looking for a post code calculator in miles for the UK by road. Does one exist for mileage by road. I have seen some mention API ( i am clueless about), so am looking for a legal version as i saw it mentioned...
  5. W

    Calculator based on differing variables

    I am hoping to be able to calculate a date range when an initial scan would be required for a patient treatment by working backwards from the date of a patient treatment and factoring in different variables. Variables would include varied timeframes based on differing complexity and staff leave...
  6. K

    Help! Need to repeat macro for all rows

    I am very basic at macros and I need some help. I recorded the below macro and I need it to repeat but for all the rows. This was just using the record macro button so I did not do all the coding. A little explanation: I have a table that is a calculator. I have a project that has a range of...
  7. G

    Help with vba code please

    I have two worksheets named “Bid Calculator” and “Legend”. I am looking for vbcode to take the number from the “Legend R4” and place in cell C29 of the “Bid Calculator” this is the first step. There are 5 cells in the row “Bid Calculator C29:G29” In the worksheet “Legend R4” I have a number...
  8. D

    Save file with current month name

    Hi, Everybody... Can you help me... i want to try to save an excel workbook with the name of the next month. Example: If today is 28/07/2018 i need that woorkbook save as "Calculator AUGUST" The next month i'll create a new one... and i need to save as "Calculator SEPTEMBER" Greetings..
  9. P

    Cycling Speed Calculator

    Morning all. I am trying to create a cycling calculator in excel for average speed. On this site, there is the "Average Speed Calculator, how can I recreate it in excel? I know the distance in miles ex. 100 and time 04:39:02.50 (hh:mm:ss.ms) looking for the average speed. Thanks...
  10. D

    Calculate retirement distributions needed to provide desired net income.

    I'm afraid to even ask this because I know someone is going to answer in a coding language that I don't understand. I have built a pretty intricate retirement calculator in excel with lots of =IF, =VLOOKUP, =SUMIF, etc. formulas. I don't know anything about macro or VGA, etc. I'm gonna try to...
  11. H

    Holiday and Sickness Calculator

    Hi, I am looking for a Holiday and Sickness calculator template where I could calculate the number of holidays/sickness taken and remaining for the year. My holiday year starts from August to July and is entitled for 20 days + bank holidays. Does anyone has a template who can share? Thanks...
  12. A

    Rounding Function

    I have a spreadsheet that is calculating a price per square foot of a building. The cell is formatted to Accounting with 2 decimal points. This is what is should be based on my calculator tape 52,000 sf x $61.68 = $3,207,360 This is what the cell multiplication tells me 52,000 x $61.68 =...
  13. D

    Tax Calculator

    Hello, Could you please help me with the file below: https://www.dropbox.com/s/22po50q2s9rl05g/Tax.xlsx?dl=0 Thank in advance
  14. L

    SIN function

    PLEASE HELP, Excel is driving me nuts I am using the SIN function and excel is producing a different value than my calculator. a quick example is SIN(90) which we all know equals 1 Excel formula is =SIN(90) which is producing 0.893997..... I use the ROUND function to get the 1, but as i...
  15. A

    Profit % margin calcaulator

    Hi, I am attempting to construct a profit margin calculator and am having some difficulty achieving the desired result. I have a basic profit calculator; profit(a4) = saleprice(a1) - cost(a2) - minus overhead(a3) and profit margin =(saleprice(a1)/profit(a4))*100 What I am trying to do is...
  16. B

    Help Making a Calculator

    Hey everyone, Here's a spreadsheet I am working on: https://www.dropbox.com/s/xavhulqwi91xamh/Profitability%20Calculator.xlsx?dl=0. My goal is to make a calculator that is streamlined and aesthetically pleasing as I can. Right now, I have set it up to do the calculations for me, but I have hit...
  17. T

    Creating a survey results calculator in Excel - a bit complex

    Alright, Excel gurus, I could use your help. I've got a bunch of survey results, and I'm expecting lots more. I'm creating a calculator in Excel to run some numbers for me faster. The main problem I'm running into is that the result I'm ultimately looking for is an average salary amount. When...
  18. C

    Different Total in Excel versus Calculator

    I'm getting different totals in excel than I am in calculator Example: Excel 39% * 436.23 = 168.5797 Calculator 39% * 436.23 = 170.1297 What am I doing wrong? Ive tried the ROUND and ROUNDUP function but it never rounds up to 170.1297
  19. C

    Forecasting - changing data for creating different forecasts

    Hi Everyone, I am working on an excel project for my business analysts diploma. I have a worksheet detailing student enrollments and finaces for a number of different colleges, I have historical data for 2015 - 2017 and forecasted data for 2018 - 2020, this shows my forecast based on the...
  20. B

    equation help

    stupid question, i am losing my mind trying to do an equation Sales Person A owns a relationship for 6 months it begins with 25,000 balance, ends up being worth 21,000 trying to get a prorated % increase/decrease value i did $21,000*(6/12)-$25,000*(6/12)/(25,000*(6/12))= -16% however doing it...

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