Can this be done?

M

Mike

If I have the following cell values:

B6 contains A
C6 contains 5
D6 contains .35

I need to set cell H6 to:

A,DCS,5A,0V,<.35V,0S,1S

where A is based upon the contents of B6
5 is based upon the contents of C6 and
..35 is based upon the contents of D6.

If I change the values of B6, C6 or D6, the contents of H6 reflect those
changes accordingly.

For example if B6=B, C6=7.5, D6=.3 then H6 becomes
B,DCS,7.5A,0V,<.3V,0S,1S

Can this be done in xcel and if so how?

Thanks

-Mike
 
R

Ron Coderre

Try this:
H6: =B6&",DCS,"&C6&"A,0V,<"&TEXT(D6,"#.0###V")&",0S,1S"

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
N

Niek Otten

Hi Mike,

=B6&",DCS,"&C6&"A,<"&D6&"V,0S,1S"


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| If I have the following cell values:
|
| B6 contains A
| C6 contains 5
| D6 contains .35
|
| I need to set cell H6 to:
|
| A,DCS,5A,0V,<.35V,0S,1S
|
| where A is based upon the contents of B6
| 5 is based upon the contents of C6 and
| .35 is based upon the contents of D6.
|
| If I change the values of B6, C6 or D6, the contents of H6 reflect those
| changes accordingly.
|
| For example if B6=B, C6=7.5, D6=.3 then H6 becomes
| B,DCS,7.5A,0V,<.3V,0S,1S
|
| Can this be done in xcel and if so how?
|
| Thanks
|
| -Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i really have no idea if this can be done... 2
HLOOKUP using variable columns 5
how can this filter be done in a macro? 8
Formula to auto calculate based on other variables 8
SUM with variable range 6
Array Formulas 5
Dates not consistent 3
Table lookup using multiple qualifiers 1

Top