How do i make a formula on a spread sheet to calculate a logical next number from a list of vertical numbers?
493156
If I understood right, I think what you looking for is (IF). \n1- click on INSERT (menu)\n2- select fx (function)\n3- select a function (IF)\n4- office assistant with guide you through
829503
I accept the challenge for the fun of it.\n\n...will get back to you.\n\n\nOK.  in cell G5, based on what you describe, the formula is "=VLOOKUP(+E5,$B$2:$C$5,2)"  Note the dollar signs in the formula referring to cells B2 and C5.  This will allow you to copy cell G5 into G6, G7, G8, and so on if you have more values in column E.\n\n\nNOTE: In column B2 to B5 are the numbers 0, 32, 63, and 94 respectively.  In column C2 to C5 are the words Freshman, Sophomore, Junior, and Senior respectively.
864388
some formulas that can help :\nhttp://www.eskridgeinc.com/support/formulas.html
431591
Use Microsoft Excel or a slide-rule
697117
Subtract the cells and format it as numeric
330924
Say you have in Cell A1 of "Sheet1" is -400...\nif you want it on Cell A1 of "Sheet2" as +ve number no matter A1 on Sheet1 will change to +ve or -ve, then put   =ABS(Sheet1!A1)\nif you want it on Cell A1 of "Sheet2" as +ve number only when A1 on sheet1 is -ve (reverse sign) then put =-Sheet1!A1\nif you want no formula as above 2, copy A1 on Sheet1, right click A1 on Sheet2 and choose paste special, check the subtract and click ok
573846
You don't need VLookup here you need another function, which is countif..\n\nif your column in C, put this function in D4\n=COUNTIF(C:C;"*banana*")\n\nand enjoy\n\nremeber, if you like it, I want my 10 points...\n\nI am the XLMan
1163223
Is there is no SUB command similar to SUM, my suggestion would be to make a second column, the same size as the one you are trying to subtract.  You can put it off screen, or so, then no one can see it.\n\nFor this example, we will assume you have the column A with the values you want to subtract.  We will also assume that column B is the new second column.  Both columns data starts at 1, ie, A1, and B1.\n\nNow, the cell B1 should have the formula '=A1' to have the same start value.\nThe cell B2 and onwards should have the formula: '=-A2', '=-A3', etc.  This is 'equals minus An'.\n\nThe get the total, have the formula as '=SUM(B1 : Bend)'\n\n[Edit]\nWhere Bend is the last row in column B, eg, B4.\n[/Edit]
871781
Simple.  Put a formula in sheet 2 that uses the value in sheet one to perform its calculation.
1109073
Assume you have only A1 to A10 contain a number of 1,2,3 and B1 to B10 contain the # of days\nput this anywhere, say B11\n=SUM(IF(A1:A10=1,IF(B1:B10>2,1,0)),0) \nyou will get #VALUE!\nthen keep your cursor stay at B11, hit F2 then Ctrl+Shift+Enter to make it an array formula, the above formula in B11 should be in brackets { }.\nTo clarify a few points in above formula...\nin the formula the A1:A10=1 is your criterion - only 1 not 2, not 3\nthe B1:B10>2 is also your criterion - over 2\nthe last 1 in the formula is if the 2 criteria on each row are met, add 1
372526
some calculators can do this\n\nmathematica software will do it
964099
Just go to the Cell that you want the total in.\n\nType +sum(d2..d6) where d2 = your first cell to be added and d6 = your last cell to be added.\n\nYou could also use the AUTOSUM button on the top toolbar.\n\nHighlight the cells you want added and hit the button.\n\nHover your cursor over the buttons till you find it.
480823
if your array is 5 wide by 46 long, then you just assign an incrementing value to each consecutive cell and you will find that the last cell (5,46) = 5 X 46.\nSee below:\n\n1,2,3,4,5,6,....44,45,46 -cell (1,46) = 1 X 46 = 46\n47,48,49,50,....90,91,92 -cell (2,46) = 2 X 46 = 92\n...\n...\n...228,229,230 - cell (5,46) = 5 X 46 = 230
636777
=(cell number+cell number) \nYou just have to click on the cell that has what you want added, subtracted or multiplied. Simple, really. And you can use more cells than that. Have fun.\nAnother formula might be \n=A(cell number+cell number)
1005206
the same way you do it with excel...
404712
You can do this by VLOOKUP\n\nSheet 1 contains the full list \nSheet 2 your item codes\n\nIn Sheet 2.\nB2=VLOOKUP(A2,Sheet1!A1:C3,2)\n\nThis looks up the value in A2 in the range A1:C3, and returns the second column (B).
971578
Nowhere, there is no such calculator. \nPossibly try an excel sheet, where you can alter the information in cells and set parameters.