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, 08:05 AM

Nibbles

Windows 7 64bit Adding an amount to a min-max range

Office 2010 64bit

Novice

Join Date: Nov 2012

Posts: 9

Got the answer from another forum, was trickier than expected but works a treat;

Code:

=IF(ISNUMBER(FIND("-",A1)),LEFT(A1,FIND("-",A1)-1)+A2&"-"&RIGHT(A1,LEN(A1)-FIND("-",A1))+A2,A1+A2)

where A1 is the 'xxx' or 'xxx-yyy' cell and A2 is the change cell

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 03:56 AM.