| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 90249 | 2008-05-27 23:28:00 | Excel help please? | Billy T (70) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 673280 | 2008-05-27 23:28:00 | Hi Team I have several graphs with multiple contours showing radiation values and I need to change all values globally by a fixed percentage to illustrated the effect of an increase in the power level from 66% (at the time of recording) to 100% . There are hundreds of individual values over several data sets and what I want to do is highlight the data fields for each set and apply a 51 . 6% increase . I am currently searching for a solution in the Excel Help files (and Excel for Dummies) but I'd appreciate it if somebody with more experience could show me the way . Even if I have to do it line by line or column by column it will still be faster than manually changing each data value . Any help would be appreciated, but I am an Excel Dummy myself so I need step by step instructions . :waughh: Cheers Billy 8-{) |
Billy T (70) | ||
| 673281 | 2008-05-28 00:01:00 | In a spare cell type the numerical multiplier you wish to apply derived from your 51.6% Highlight the data that needs mutiplying, copy, paste special, select values, and select multiply You can then delete the spare cell contents. |
godfather (25) | ||
| 673282 | 2008-05-28 00:50:00 | In a spare cell type the numerical multiplier you wish to apply derived from your 51.6% Highlight the data that needs mutiplying, copy, paste special, select values, and select multiply Hi GF, nice to know you are still lurking out there. So, allowing that I am definitely a dummy on this stuff, I enter 1.515 in a spare cell, highlight all the data fields, copy, paste special (onto itself effectively) select "values" then select "multiply" and it will all magically transform? Correct? This is for the Nokian SVC at the Albany Sub. BTW if you are curious, I think we discussed this some time back, but it was a long time coming. Cheers Billy 8-{) Nope, gave me a whole pile of huge values with some cells in the top right of the data table having alpha-numeric stuff instead. How does Excel decide which cell has the required multiplier?? I just put the multiplier in a cell above and to the right of the data and it looks like it wasn't found. Yes, it is simply squaring the number in each cell and taking no notice of the multiplier. |
Billy T (70) | ||
| 673283 | 2008-05-28 01:55:00 | Make sure your data cells are formatted as numbers. 1.51 is what you put in a blank cell, to get a 51% increase. Click copy on the 1.51, highlight the cells you want to increase, right click, paste special, click multiply. | wotz (335) | ||
| 673284 | 2008-05-28 02:13:00 | Woo Hoo!!!!!!!!! We have ignition. We have lift-off. We are on our way! Thanks GF & Wotz, it was my mistake, my cells were set to general not numbers, and I can't follow instructions. :( Cheers Billy 8-{) :thumbs: :D |
Billy T (70) | ||
| 673285 | 2008-06-06 12:42:00 | :spam? | beeswax34 (63) | ||
| 1 | |||||