|
|
#4
06-13-2013, 07:39 AM
|
|||
|
|||
Ah, right a problem.
The problem is that I want the adjustment to be applied to last months value. So if last month was 100, adjustment 20 would be 120 for this month. Then if next month the adjustment is 50 it would return a value of 170. However, for the ranges the cells read 'xxx-yyy' so i would therefore need a way for that =TEXT formula to take the first value only (xxx) and add the adjustment, then the second value only (yyy) and add the adjustment. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 how to cut and paste for the range
|
tomlam | Excel Programming | 5 | 12-26-2012 02:20 AM |
|
use VBA to name a range
|
g48dd | Excel Programming | 7 | 06-20-2011 06:34 AM |
|
Adding Image into a excel cell and adding a hyperlink to the image
|
saravananiyyanar | Excel | 3 | 05-04-2011 08:31 AM |
| Sort Range | boutells | Excel | 1 | 07-15-2009 03:02 AM |
|
Range Formula
|
aleksandr | Excel | 10 | 05-18-2009 12:14 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode