Hide formula in list Hi, I´ve made a list i Data Verifying that should display the options 0 or 1. 0 just being the digit 0 and 1 being the formula =SUM(D3)+1. How to I get 1 as an option in the list and avoid having to show the formula in the list? Thanks in advance. ... 18 Mar 2010 11:43 Formula Result is different from the shown result In the Function Arguments dialog the official Formula Result is different (and wrong) from the result shown after "=" just under the Serial number field. I am using the Year formula. Whatever formatting I use for the date neither this formula nor Text to Columns can return the correct year. EG: Date is 15-05-... 18 Mar 2010 13:01 I think I need a multiple IF statement, or is there another wa =A1-(A1*IF(A1<=50,10%,IF(A1<=100,20%,IF(A1<=500,30%)))) -- Jacob "Carl Waring" wrote: Actually, scratch that. I mis-interpreted what I needed to do but I can't edit or delete the post :-( That said, it still might be useful to know ;-) This is what I need to know! If the number in [cell... 18 Mar 2010 07:05 I think I need a multiple IF statement, or is there another way? I can do the simple stuff, but this is more complicated! In English, this is what I want to do If the number in [cell] is <=X then take off % then If the number in [cell] is <=Y then take off a further % then If the number in [cell] is <=Z then take off a further % then Display result It's probably as ne... 18 Mar 2010 07:05 column corresponding to row number I have 63 file. My data set on to column X, and G2 is row number related to column X. I need to macro or formula, when run it on any file, copy of column X paste to new file(R.xls) in sheet1 on column H and set to actual row number. For example: G2 is 7800 (row number), now, run macro, then copy of column X, ... 18 Mar 2010 04:51 Degrees Minutes Decimal Minutes to Decimal Degrees. Hi All, I have got a worksheet with cells like: E174 36.992 I need to get that into decimal degrees like E174.61653 Is there a way to do this with a forumla? I start with find, left, right functions, but I ended up parenthesis hell. Cheers -Al ... 18 Mar 2010 07:05 Formulas that recognise data from two worksheets I want to use data that is entered in one worksheet to calculate an equation in another worksheet. But i want worksheet one data to be recognized and correlated with data in worksheet two before the calculation happens. For example if i enter a type of material, the colour and the amount of metres cut, i want th... 18 Mar 2010 01:36 How do I find a value in a table without using the labels? I have a table with a bunch of values. I need to find a value from the chart. the values are numbers based on different areas of steel. The values are the list by column one having one times the area to column 18 having 18 times the area. The problem comes because if the areas are listed for the first colum... 18 Mar 2010 05:58 sumif concatenate formula I have 3 cells in a row. We'll call them cell 1, 2 & 3. I need a formula in cell 3 that is based on what is in cells 1 and 2. Example: 1 - If there is a letter "A" in cell 1 or 2, then concatenate cells 1 and 2 in cell 3. 2 - If there is number in cell 1 and 2, then sum cells 1 and 2 in cell 3. Thanks for yo... 19 Mar 2010 01:39 Auto calculate I am trying to find a formula that automatically calculates multiples of 32. if it is not a multiple of 32 then I wnat he cell to be blank. Any suggestions? if page count =32 then sig should = 1 if page count = 64 then sig should = 2 and so on.... See spreadsheetsample below. I manually have to fill in th... 17 Mar 2010 17:26