Question about Microsoft Excel Computers & Internet
...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 ...
Question about Microsoft Excel Computers & Internet
...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 ...
...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
...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 ...
Question about Microsoft Excel Computers & Internet
...to get the date of the LWD (Monday thru Friday) of the month. Assumed that if the date in cell A1 is 6-May-2005. then formula will be ...
Question about Microsoft Excel Computers & Internet
...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), ...
...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: ...
...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
54 questions posted
Usually answered in minutes!
592 Questions
22 Questions
12 Questions
2 Questions