Adding an amount to a min-max range

		Microsoft Office Forums > Microsoft Excel > Excel
Adding an amount to a min-max range

06-13-2013, 07:22 AM

CGM3

Windows XP Adding an amount to a min-max range

Office 2007

Advanced Beginner

Join Date: Oct 2009

Posts: 38

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.

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:56 PM.