Thread: Adding an amount to a min-max range
View Single Post
 
Old 06-13-2013, 07:22 AM
CGM3 CGM3 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default
What is the formula you use for the "singleton" cells? If it's something on the order of:

Code:
   =100 + adjust
(where adjust is the cell with the adjustment value), you should be able to apply it to the min-max ranges with something like:

Code:
    =TEXT(150 + adjust, "£0") & "-" & TEXT(175 + adjust, "£0")
Granted, this does make the cell contents text, but I don't know if that matters.
Reply With Quote