calculator

Hi, Hopefully someone can help me. Any ideas how I can create my own calculator like the one on the following link but in an Excel workbook? http://www.westpak.com/page/resources/accelerated-aging-time-calculator Many thanks!

Hi guys, I posted a question regarding this recently but I don't think I worded it quite correctly and after some consideration have come up with a clearer (wordy) way of trying to calculate something which would be awesome if someone could convert to excel language for me! I am trying to...

Hello . I have a request for you . I want a dutching calculator who can change the profit on certain selections as I want . As an example , lets say 3 correct scores , with odds of 3 and a stake of 30 . A simple dutching calculator will spread the stake evenly on the odds to generate the same...

I need to make a workbook that contains sheets of different products. For every product, there's a list of the processes it need to produce it, including the time each process takes, and the employees needed per process. Been trying to make an easier format wherein you just input the quantity...

Hello Ladies and Gentlemen, Just like the title says, I need some guidance with this project. I am part of a very small transport company and am trying to make a workbook that I can input parameters into and it will spit out a dollar amount that it would cost my potential customer. Below are...

Hello all, I am a novice and before writing this post I did try to see if this question had been answered previously. I have data in a date format in column "I" which I would like to be automatically entered in the neighbouring cells in column "J" but with 3 months added to the original date...

Hi guys, im just making a simple spread sheet and need to work out a formula for NSW stamp duty: on sheet 1 i have the house value in cell B3, and on sheet 2 i have the stamp duty amounts so i can have them separate/not visible from sheet 1: <tbody> $0 - $14,000 $1.25 for every $100 or part...

Hello everybody, How is it that this equation, correctly counted in Excel, 300*(1/0,005-1/(0,005*1,005^48))=12 774,10 gives me over and over again 42,58 counted with a calculator? Any help will be appreciated. Thanks.

i have a sheet that does alot of math, every time i want to change a cel number i have to open win calc, is there a way i can insert a popup calc that will do the math for that cell and then only display the result in said cell ? eg: i click on b12 and *pop* it shows a popup calc. 20+67+300=...

I have been asked to create a spreadsheet that will calculate a Data Retention Date depending on a number of elements. The Field Names & Rules would be as followed: Field 1: Enter DOB Field 2: Age (Calculated on Field 1) Field 3: Enter Date of Initial Review Field 4: Enter Date of Follow Up...

Hi, I have been tasked with creating a profit margin tool within Excel that is interactive and able to load a customer account's sales history data. It must allow the user to perform "what-if" scenarios in Excel, in order to test the revenue effects of increasing/decreasing the profit margins...

Hello I need help with a formula to calculate finance charge with the following variables..I need a value for finance charge ( buy rate) and finance Charge( sell rate) Please help: <colgroup><col span="3"><col><col><col></colgroup><tbody> Buy Rate Sell Rate Amount Financed Term Finance...

Im sure this has been posted but after reading over this forum and others i still cannot find a solution. Given the first two columns of IP addresses i want to generate the third or even fourth Column <tbody> StartIP EndIP Total IPs Total /24s 1.32.0.0 1.32.127.255 32,766 128 2.15.0.0...

I am writing a program in VBA Excel 2010. The program is basically a self service concession stand which allows for certain members to keep a tab (negative balance), but other users must pay. There a user can type in his or her ID numbers, and items name, balance, and purchase history will...

Greetings, I want a formula to calculate annual leaves for employees. I've been looking through the forums and found something similar > http://www.mrexcel.com/forum/excel-questions/677610-calculation-leave-days.html < But the formula wouldn't suit what we're working with. I could use some...

Hello all, I'm building a cost calculator and I need to use different formulas in a single cell. I have an end price that could meet three pricing conditions, here they are: Small Paperback Book: Page Count: 18-46, $1.04 per unit Page Count: 48-106, $1.61 per unit Page Count: 108+, $0.63 per...

Hi, I have an annoying issue with a spreadsheet im trying to design. Basically, I have a table ( 5 colums by 30000ish rows) with data that is constantly changing and therefore constantly needs refreshing. downloading the data into the spreadsheet itself isn't a problem. However, I have formulas...

Hello, I am struggling to figure out how to go about this, perhaps someone can point me in the right direction? I wish to create a variable dutching calculator whereby, instead of all the runners in the field generating the same profit, one can be weighted to more than the rest. For example...

Hello - I have two lists that I am working with - one that has the dimensions of a product and one that has the dimensions of the available shipping boxes. I need to compare the length, width and height of the product to the dimensions of the box and determine which box is the best fit. I...

OK, I know that you can use scripts to call calculators such as the following. Sub OpCalc_Click() 'Standard Module code! On Error GoTo Err_OpCalc_Click ActiveSheet.Select 'Open the Calculator! Call Shell("Calc.exe", 1) Exit_OpCalc_Click: Exit Sub Err_OpCalc_Click: MsgBox Err.Description...