Questions & Answers for: Microsoft Excel variable science

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 ...

...Picture 1 column for yes responses, 1 column for no responses, the total number of responses is a variable. Now I need to develop a percentage cell for yes and a percentage cell for no responses

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 ...

...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 ...