| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 49395 | 2004-09-18 00:36:00 | Excel Problem | heaton (3697) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 273381 | 2004-09-19 04:32:00 | Hi Heaton, another way is to drop your figures down a row and have your depn. in B1, and make it perm. if rates change you only have to change cell B1. Copy B2 down. 2.50% =+A2*B$1 100 2.50 97.50 110 2.75 107.25 120 3.00 117.00 130 3.25 126.75 140 3.50 136.50 150 3.75 146.25 160 4.00 156.00 170 4.25 165.75 180 4.50 175.50 190 4.75 185.25 200 5.00 195.00 210 5.25 204.75 220 5.50 214.50 230 5.75 224.25 240 6.00 234.00 250 6.25 243.75 260 6.50 253.50 270 6.75 263.25 280 7.00 273.00 Les 3. |
leshibbard (873) | ||
| 273382 | 2004-09-19 05:15:00 | Heaton I don't know if you are aware of this page, I can recommend the XLFDIC01 file. Download as a zip and don't worry about the macro warnings when you run it in Excel. homepage.ntlworld.com |
zqwerty (97) | ||
| 273383 | 2004-09-20 00:45:00 | Thanks again chaps, I downloaded that file querty and it appears to be a help file. One of the problems with help files is knowing what to look for. I tried all sorts of terminology but could not find how to do this simple thing. Why don't they have a help item saying something like " how to enter formulae in selected cells." Guess I am asking too much. Anyway I know how to do it now thanks to Press F1 which is a really helpful website. Cheers. |
heaton (3697) | ||
| 1 2 | |||||