...4 of a number rounded up and then the rounded up number as full number suppose ur number is at cell B2 with any value. lets say u want formula in A3. then A3 =*b2*3/4 to round back the A3 to full ...
...next to that column; for example - if column A has duplicates, insert a column (B) and starting in B2 put if(A2=A1,"DUP",""). Select B2 and scroll down to the bottom of your spreadsheet. Press -D to ...
...example i am doing a report using excel. I have no. 5 in sheet1 cell a2 and nos. 2,45,6,76,88 in b2,if i click sheet 2 the output must be sheet 2 cell a2 b2 5 52 5 545 5 56 5 576 5 588 You can do ...
... So start a spreadshhet and put the start date (01/01/2009) in A2 and the end date (31/12/2009?) in B2. Then paste the formula below into C2: ...
...you can get the minimum number from that area. Example: A1: 6 A2: 8 A3: 3 A4: 9 A5: 2 A6: 7 in B2 we want to pick the smallest value in that group and multiply it with 60. This is what you type ...
...the time format "h:mm AM/PM". Lets say the start time is in cell A2 and the stop time is in cell B2. In cell C2 put the formula =B2-A2 and custom format the cell C2 as:
...that takes into consideration three cell and returns a value of x. So if A2="Clark College" and B2 Is not blank OR C2 =Graduate then give me a value of x. I'm not sure this can be done but if it ...
...0.2 of a number, 80% means 0.8 of a number So If you have 200 in Cell B1 And you want 20% less in B2 Goto B1 type 200 Goto B2 type like this =B1*.8 and press ENTER Now Cell B2 displays 160 which is ...
...Type in A1 "hypotinuse " Type in A2 "Left Angle" Type in A3 "Right Angle" Type in B1 90 Type in B2 "whatever the value given for the left angle" Type in B3 =90-B2 As soon as you change the value ...
...column B plus the word on column H row 2...what is the formula? example: a2(dentist) h2(chico) on b2 must be "dentist chico" You could use Concatenate command. Means to join together. B2
Usually answered in minutes!
7,276 Questions
4,613 Questions
4,482 Questions
4,191 Questions
3,681 Questions
