Questions & Answers for: Microsoft Excel variable defined

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 -

...get the start date for each employee as 26 of every month Make that column fixed and give the variable date and value 26/Month of year/year That is the logic Can you do that

How do I run a regression analysis in Excel What is the tool/steps to plot a regression curve/line against a set of points in excel? I have used this functionality many years back, but cant remember ...

Excel lookup - match index array Hi, Any ideas & help appreciated Excel spreadsheet with around 100,000+ names, titles, numbers, Title & Notes across multiple sheets I need to a formula search the ...

Need a range answer in excel I'm calculating a range (15-25%) of a variable in another excel cell and want this new cell to answer with the range (.15*b27 to .25*b27), rather than a single answer. Is ...

i am unable to define values between the words hi sir i am mukesh kumar i am trying to get value between the words like sandeep22mohan sam26jammy like this sequnce many words are plz help me if ...

...where you have x=x+1. Loops using For Next don't need a statement to add 1 to the value of x. The variable x will automatically be increased by 1 each time the program reaches the Next x statement. ...

I can't open SYLK file are you trying to open a txt file or a comma-separated variable (CSV) file and i bet the chances of the file name having a capital "I: or "D" are good huh. To open your file in ...

If I have a multi-row s/s that has multiple pages, how do I get the row title for columns to appear on each page? Hi, I believe you're asking about 'freezing panes'... In Microsoft Excel 2007: Select ...

delete name ranges It's a bit counter-intuitive... Go Insert / Name / Define and the Define Name Dialog box will open & display the existing Range Names. Select a Range Name to delete and hit the ...