Variable tax rates in Excel Hello all How do I write a formula that will do the following - If taxable income is: $0-$6000, tax is nil. $6,001 - $21,600, tax is 17c for each $1over $6,000. $21,6001 -
Help with simple excel calculations im sure this is simple for you but it has been driving me crazy. I need the value in a1 to equal b1 then when i put a value in a2 i want the sum in b2 and so forth.
horizontal Is there a way to dynamically summarize a row of data ($$) under a row of dates to include each new month. In other words can I create a YTD number at the end of the row, without having to ...
excel formulas Premium Age of Client (% of car value) Under 25 10% Over 25 5% Here is your formula =IF(A1 < 25,10/100 * B1, 5/100 * B1) A1 is the Age of client B1 is the car value to totally exclude ...
If you want to withdraw Rs 25,000 at the end of each year for the next 7 years then what amount must you invest today at 5% compounded quarterly? *269/112.5*100*20*10 pv=R(1-(1+i)^-n/i)
percentage formula need a formula for working out 30% for any given figure to add into a spreadsheet =(Click cell that you want to work out 30% of)*30/100
excel forrmulas want solution tshurt 100,200,300 pent 1200*100=
Trying to write a loop using excel text boxes such as: Dim x as integer for x= 0 to 100 textbox(x).backcolor=vbWhite x=x+1 next x Not working any thoughts thanks You don't say how your program is not ...
how to calculate percentages What is the formula for computing 6% of 13,200 If you multiply a number by 1, this is equivalent to 100%.So the calculation would be 13,200 x 0.06
how to create a formula for increase decrease percent in excel If you have a number in Cell A2 (say 100), and you put the amount of percentage increase or decrease in Cell A3 (say -10%), then put this
Usually answered in minutes!
592 Questions
43 Questions
22 Questions
12 Questions
