Can this be done?

TheMSsForum.com: The Microsoft Software Forum

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
Top

Re: Can this be done? by Ron

Ron
Thu May 08 09:29:17 CDT 2008

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)


"Mike" <Mike@discussions.microsoft.com> wrote in message
news:90CB30A5-B5F2-4A0D-B2F0-260A87938EC5@microsoft.com...
> 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


Top

Re: Can this be done? by Mike

Mike
Thu May 08 09:38:04 CDT 2008

Thanks Ron

Wonderful!
Yes, this will work. Perfect.

Thanks again :-)

-Mike

"Ron Coderre" wrote:

> 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)
>
>
> "Mike" <Mike@discussions.microsoft.com> wrote in message
> news:90CB30A5-B5F2-4A0D-B2F0-260A87938EC5@microsoft.com...
> > 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
>
>
>
Top

Re: Can this be done? by Niek

Niek
Thu May 08 09:41:09 CDT 2008

Hi Mike,

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mike" <Mike@discussions.microsoft.com> wrote in message news:90CB30A5-B5F2-4A0D-B2F0-260A87938EC5@microsoft.com...
| 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


Top

Re: Can this be done? by Mike

Mike
Thu May 08 09:51:06 CDT 2008

Thanks Niek!

Looks and works great :-)

-Mike

"Niek Otten" wrote:

> Hi Mike,
>
> =B6&",DCS,"&C6&"A,<"&D6&"V,0S,1S"
>
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Mike" <Mike@discussions.microsoft.com> wrote in message news:90CB30A5-B5F2-4A0D-B2F0-260A87938EC5@microsoft.com...
> | 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
>
>
>
Top