Questions & Answers for: Microsoft a1 21 Computers & Internet

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

...and division, respectively. Please see the examples below. Add 1 + 1: =1+1 Add the contents of cell A1 to the contents of cell B1: =A1+B1 Subtract 2 - 1: =2-1 Add the contents of cell A1 from the ...

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

...I am trying to meet certain conditions with and statement also there is alot of conditons. example: a1=G110581f or N110582f or 110582f a2=pool or customer or retired or gfe a3= N or G or O or L in ...

mrps =if(a1>=36,a1=<47),''III'',If(a1>=48,a1=<59,''II'',if(a1>=60,''I'',''F''))) please correct to formula to prepare my school's resultsheet and grading sutdents progress report. Use this as a ...

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