VAT calculator

Instead of having to pull up the calculator off the start menu then transfer
that data to excel, it would be great if we could have a way to calculate
within the cell we want the data.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

Hi there is it possible to do the following?

Is is possible to create a calc for simple data input and assign this to cell U31 so that everytime user selects this cell then the calc pops up.

I didnt want to use an add-in in case other users don't have this add in on their computer.

Any suggestions here please>
Thanks in advance.

Hi Guys,

I need help with this formula I've been trying to make. I want to have the Total tax computed automatically. There is so much data it can't fit using the IF formula. Please help. I appreciate it.


















Basic Pay



10000

Exception Status S





Less: Total Tax



1770.75









Net Pay



8229.25
























I need a Macro to compute the Total Tax automatically.


Formula:
10000




Less
6667




Multiply by Rate
3333 x 25% 833.25

Add



937.5


Total Tax

1770.75






























































This is the tax table:

SEMI-MONTHLY TAX TABLE











1 2 3 4 5 6 7 8









Exception - - 20.83 104.17 354.17 937.5 2083.33 5208.33 Status ('OOOP) - 5 10 15 20 25 30 32









S 20 1 833 1250 2083 3750 6667 11250 21337 HF 25 1 1042 1458 2292 3958 6875 11458 21875 ME 32 1 1333 1750 2583 4250 7167 11750 22167 HF1 33 1 1375 1792 2625 4292 7208 11792 22208 HF2 41 1 1708 2125 2958 4625 7542 12125 22542 HF3 49 1 2042 2458 3292 4958 7875 12458 22875 HF4 57 1 2375 2792 3625 5292 8208 12792 23208 ME1 40 1 1667 2083 2917 4583 7500 12083 22500 ME2 48 1 2000 2417 3250 4917 7833 12417 22833 ME3 56 1 2333 2750 3583 5250 8167 12750 23167 ME4 64 1 2667 3083 3917 5583 8500 13083 23500

Hi,

I am trying to make a GPA calculator so that I know how well I have to do on my finals. I have one that works, but I would like to make it a bit simpler. As of right now, I have one column where I put my grades (B, B+, etc) and in the column next to it, I put the grade points for that class (3.0, 3.3333, etc) where I can then use those numbers for calculations. Is there a way I can have the second column display the proper number as a function of the first column; as in, if I type in 'A' in the first column, it will put '4' in the second, if I put 'B-' in the first, it will put '2.6666' in the second. I know I can just do this manually, but I am lazy and I am also seeking to increase my excel knowledge. Thanks!

I am creating a world cup draw and want to know how to calculate the # of points a team receives based on how many wins/ties they have. (3pts per win, 1 per tie). As per the table below i want the function to look through the array, find the team name "france" then determine if "HS" is greater than or equal to "AS" and return a value of 3 for each time France wins, and 1 point for each time they tie, and zero points for a loss.

any suggestions would be greatly appreciated- i would like to stay away from macros if possible


Home HS AS Away france 2 1 Brazil Italy 0 0 Slovakia germany 1 2 France France 3 1 Slovakia

Hi All anyone knows how to make a Return on Investment Calculator

Thanks
Keran

Hi All,

Does anybody have a template for calculating Income Tax? Preferraly with current rates/bands.

I know you can do this on the web but I'd like to get it in a spreadsheet to merge it with other income & outgoings etc.

Any help would be much appreciated.

Greetings,

Could anyone post the code to perform basic calculations (+,-,*,/, sqr) in
hex base.

Even more, if there's any code to build a sci-calculator available would be
really appreciated.

Best regards.

--
lrenteria arroba hotmail punto com

Could someone please tell me how I would do this in a form?



What I want to be able to do is, much like a calculator, punch in the numbers and then show the total price of an item.

Much like a till/cash register system.

Thanks in advance.[/img]

Hi Friends,

I have inserted a button for calculator in EXCEL, but is there a way wherein (like the calendar in excel) that if you choose a certain cell in the sheet that what you have calculated in the calculator will directly be loaded to that cell?

thanks,

splucena