Questions & Answers for: Microsoft Excel a1 21

...having 10 rows & 12 column datas. I need 1,2 & 3 rd pages sum in 4th page. Ex. I need 1,2 & 3 page A1 sum data in 4th page A1. I need formula for this. Please suggest me. at first select the 1st

...a cell based on the value in another. Let's assume that you enter your score (A, B, C or D) in cell A1. If you put the following equation in cell A2 it will then display the corresponding score: ...

...then have that info sent to another sheet that is in the same file? hello yes it is. example sheet1 A1 (50) A2 (50) sheet2 (A1)= "=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1 ...

21/2005 How to I calculate years using a starting date and having it display in date format? Thank you Here is one way I just tried: Say the date purchased is in A1. You want the Est Life in A2. In A2

...4 - 10.29*d^(-1.333) = 0.124 "d" to the power X "I hope Trial and Error method " Thanks for help In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein ...

...Hi, Here is an example of what I want to do (Excel 2004 Mac). If I put the number 1 in a cell (A1) I want the word GOOD to appear in cell (B1), if I put the number 2 in A1 I want the word FAIR

...column to calculate the amount from 2,000,001 to 5,000,000. Can it be done? Lets say you want Cell A1 is the number that you want to determin which column you want it to go in...try this formual you ...

i need a formula length of service in DD/MM/YY on MS Excell Format cells A1 and B1 to dates. A1 is the first date B1 is the 2nd date C1 enter the formula below =DATEDIF(A1,B1,"y")&" years ...

...such as +,-, *,/ for addition, subtraction, multiplication or division. For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. Other formulas refer to different functions ...

...AND DECREASE There isn't a function for this, but the formula should be something like this: A1: Number to increase / decrease B1: % change C1: 'INC' or 'DEC' D1: =IF(C1='INC', A1+(A1*B1), ...