Well you got part of it right. I need the AV1- to stay constent and the -
number to change 20 times.
example.
AV1-1
AV1-2
AV1-3 etc.

What i'm using for to calculate circuit voltage by device. So, AV1 is the
circuit and -1 is the device. There will be multiple circuits, so if I could
get the first one working I can use it to figure AV2-, AV3, etc.
I hope I cleared up what wanted to do or did I make it worse. :)


"Excel_Geek" wrote:


Not sure i completely get what you're after, but you can do this:

=IF('A-V Input'!B200,D6&"-1","")

to reference teh value "AV1" in cell D6 and add to it the text "-1".

Then if E6 and on down have AV2, AV3, etc., copying this formula down
will reference them, and create "AV2-1", "AV3-1", etc.

Is this what you're after?


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=399602