Question about Microsoft Excel Computers & Internet
When i copy a sum formula in excel the first cell does not remain the same it increments by 1. how can I prevent this? There are 2 types of direct cell references that you can use when you're writing ...
If formula I need some help with the if function. I am trying to copy a formula into a new cell only if data is entered into another new cell. EX: If C8<0 then copy the formula from G7 to G8 use the ...
Question about Microsoft Excel Computers & Internet
Copy data that contains formula and paste it to a new sheet minus the formula: is this possible? Sure is - depending on your version of Excel. 1) right click on the cell with the formula 2) go to ...
Question about Microsoft Excel Computers & Internet
How to number a column. I can't remember the short formula, something like a1+1= which would make the number two pop up in the cell underneath. You can number rows in a column by entering a number in ...
Question about Microsoft Excel Computers & Internet
MS Excel-Values in the formula in place of cell reference MS Excel-I want to view values in place of cell references in the formula. I have typed cell reference but I want to view values of the cells ...
FORMULA NEEDED FAST Project I am working on has the following: Base Rate, Opt Yr 1, Opt Yr 2, Opt Yr 3, Opt Yr 4. I need each Opt Yr to calculate Base Rate + 5%, However, I have 40 rows to do this for
Question about Microsoft Excel Computers & Internet
When I enter a formula the cell displays the formula and not the result. For instance, I type: =left(L27,13) Instead of showing me the 13 leftmost characters in cell L27, it shows ''=left(L27,13)''. ...
Formula required Problem:1st exel sheet having 10 rows & 12 column datas.2nd exel sheet having 10 rows & 12 column datas.3rd exel sheet having 10 rows & 12 column datas. I need 1,2 & 3 rd pages sum in
Question about Microsoft Excel Computers & Internet
how to calculate an average on a cell by cell basis ? need to calculate an average for each cell for example A1, then A1,A2 etc through 5000 rows. John In cell B1 put the formula =AVERAGE(A$1:A1) Copy
excel formula in a1 i put 1st i want a2 to show 6 if 2nd i want 5 if 3rd iwant 4 and so on I'm assuming you'd like to assign a numerical value to cardinal references (1st, 2nd, 3rd, 4th, etc.). Best ...
54 questions posted
Usually answered in minutes!
592 Questions
22 Questions
12 Questions
2 Questions