Microsoft Excel for PC "create formulas" Questions

...Yr 4. I need each Opt Yr to calculate Base Rate + 5%, However, I have 40 rows to do this for. Can I create a formula outside the cells I am using that will automatically calculate each time I put a ...

...solution This is what i need to do. I need to calculate accumulated hours from two inputs. example. Create date: 10/19/2008 13:08 Due date: 10/23/2008 13:08 then i need a formula that will calculate ...

Text and nos. in one cell, nos. to be used to create formula. I wish to know how to use nos. from a cell having text also along with the nos. Suppose I have 'episodes 208' in one formatted cell with ...

"index" formula - "function argument box" correct - cell wrong! I have created an index formula (with reference). In the function argument box it returns the formula result as I know it should be ...

...additional lot of 2500 members). Using IF function or filter to generate the membership type and create a VLOOKUP for that..... Or using filter function you could create a pivot and insert the ...

...a numerical value to cardinal references (1st, 2nd, 3rd, 4th, etc.). Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of

...create a YTD column at the end of the second row showing: 1500 YTD Total. Then for June include June dynamically (1600) etc.... Thanks! Phil Not sure if I get your problem. Do you mean the SUM() ...

formulas contain a circular reference and may not calculate correctly. Circular reference are any refereces within a formula that depend upon the results of that same formula. For example, a cell that

...make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform ...

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