#### help with formula #4

```In cell I8 I put a 1 or 2
If I put 1 then I want cell M7 tp show �150
If I put 2 then i want cell M7 to show �125 and cell M8 to show �125

As a variation if its easier I would be happy with cell I8
If I put 1 then I want cell M7 tp show �150
If I put 2 then i want cell M8 to show �100,   as either way it would show a
total of �250

thanks

```
 0
me6808 (48)
7/2/2005 6:04:59 PM
excel.newusers 15348 articles. 2 followers.

16 Replies
458 Views

Similar Articles

[PageSpeed] 46

```Have a look in HELP index for

IF

--
Don Guillett
SalesAid Software
donaldb@281.com
"Scudo" <me@nospam.fictional> wrote in message
news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> In cell I8 I put a 1 or 2
> If I put 1 then I want cell M7 tp show �150
> If I put 2 then i want cell M7 to show �125 and cell M8 to show �125
>
> As a variation if its easier I would be happy with cell I8
> If I put 1 then I want cell M7 tp show �150
> If I put 2 then i want cell M8 to show �100,   as either way it would show
a
> total of �250
>
>
> thanks
>
>

```
 0
Don
7/2/2005 6:11:57 PM
```Try this:

In M7:
=(I8=1)*150+125*(I8=2)

In M8:
=125*(I8=2)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Scudo" <me@nospam.fictional> wrote in message
news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
In cell I8 I put a 1 or 2
If I put 1 then I want cell M7 tp show �150
If I put 2 then i want cell M7 to show �125 and cell M8 to show �125

As a variation if its easier I would be happy with cell I8
If I put 1 then I want cell M7 tp show �150
If I put 2 then i want cell M8 to show �100,   as either way it would show a
total of �250

thanks

```
 0
ragdyer1 (4060)
7/2/2005 6:22:12 PM
```That worked RD

thanks

"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> Try this:
>
> In M7:
> =(I8=1)*150+125*(I8=2)
>
> In M8:
> =125*(I8=2)
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
> "Scudo" <me@nospam.fictional> wrote in message
> news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> In cell I8 I put a 1 or 2
> If I put 1 then I want cell M7 tp show �150
> If I put 2 then i want cell M7 to show �125 and cell M8 to show �125
>
> As a variation if its easier I would be happy with cell I8
> If I put 1 then I want cell M7 tp show �150
> If I put 2 then i want cell M8 to show �100,   as either way it would show
a
> total of �250
>
>
> thanks
>
>
>

```
 0
me6808 (48)
7/2/2005 6:39:31 PM
```That's very clever RD........I've never seen it done like that.

I would have just used the old time
=TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in M7
and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.

Vaya con Dios,
Chuck, CABGx3

"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> Try this:
>
> In M7:
> =(I8=1)*150+125*(I8=2)
>
> In M8:
> =125*(I8=2)
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
> "Scudo" <me@nospam.fictional> wrote in message
> news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> In cell I8 I put a 1 or 2
> If I put 1 then I want cell M7 tp show �150
> If I put 2 then i want cell M7 to show �125 and cell M8 to show �125
>
> As a variation if its easier I would be happy with cell I8
> If I put 1 then I want cell M7 tp show �150
> If I put 2 then i want cell M8 to show �100,   as either way it would show
a
> total of �250
>
>
> thanks
>
>
>

```
 0
croberts (1377)
7/2/2005 10:55:26 PM
```Chuck and RD

Clever! `It works` and for the life of me I can`t (couldn`t ever never, old
time! or  new time!) understand either of them.  I look at the formulas and
try and work out how they work. I don`t know what they feed you guys on but
it sure seems to work, keep eating the stuff :-)

really do appreciate it.

Scudo

"CLR" <croberts@tampabay.rr.com> wrote in message
news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> That's very clever RD........I've never seen it done like that.
>
> I would have just used the old time
> =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in M7
> and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > Try this:
> >
> > In M7:
> > =(I8=1)*150+125*(I8=2)
> >
> > In M8:
> > =125*(I8=2)
> > --
> >
> > HTH,
> >
> > RD
> > ==============================================
> > Please keep all correspondence within the Group, so all may benefit!
> > ==============================================
> >
> > "Scudo" <me@nospam.fictional> wrote in message
> > news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > In cell I8 I put a 1 or 2
> > If I put 1 then I want cell M7 tp show �150
> > If I put 2 then i want cell M7 to show �125 and cell M8 to show �125
> >
> > As a variation if its easier I would be happy with cell I8
> > If I put 1 then I want cell M7 tp show �150
> > If I put 2 then i want cell M8 to show �100,   as either way it would
show
> a
> > total of �250
> >
> >
> > thanks
> >
> >
> >
>
>

```
 0
me6808 (48)
7/2/2005 11:42:39 PM
```Thanks for the feed-back.

As far as the formula is concerned, just remember,
True = 1
False = 0

Put this in a cell:
=(I8=1)
And enter a 1 in I8
You get True

Change I8 to a 2
You get False

NOW, change the formula to any of these, and see what happens:
=--(I8=1)
=(I8=1)+0
=(I8=1)*1

So,
If I8=1 is True, then I8=2 *must* be False, so the formula becomes,
(1*150)+(125*0)
(150)+(0)
150

And of course, vice versa if I8 = 2

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Scudo" <me@nospam.fictional> wrote in message
news:PDFxe.335\$vF2.40@fe1.news.blueyonder.co.uk...
> Chuck and RD
>
> Clever! `It works` and for the life of me I can`t (couldn`t ever never,
old
> time! or  new time!) understand either of them.  I look at the formulas
and
> try and work out how they work. I don`t know what they feed you guys on
but
> it sure seems to work, keep eating the stuff :-)
>
> and thanks for your help
> really do appreciate it.
>
> Scudo
>
>
> "CLR" <croberts@tampabay.rr.com> wrote in message
> news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> > That's very clever RD........I've never seen it done like that.
> >
> > I would have just used the old time
> > =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in M7
> > and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > > Try this:
> > >
> > > In M7:
> > > =(I8=1)*150+125*(I8=2)
> > >
> > > In M8:
> > > =125*(I8=2)
> > > --
> > >
> > > HTH,
> > >
> > > RD
> > > ==============================================
> > > Please keep all correspondence within the Group, so all may benefit!
> > > ==============================================
> > >
> > > "Scudo" <me@nospam.fictional> wrote in message
> > > news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > > In cell I8 I put a 1 or 2
> > > If I put 1 then I want cell M7 tp show �150
> > > If I put 2 then i want cell M7 to show �125 and cell M8 to show �125
> > >
> > > As a variation if its easier I would be happy with cell I8
> > > If I put 1 then I want cell M7 tp show �150
> > > If I put 2 then i want cell M8 to show �100,   as either way it would
> show
> > a
> > > total of �250
> > >
> > >
> > > thanks
> > >
> > >
> > >
> >
> >
>
>

```
 0
ragdyer1 (4060)
7/3/2005 6:38:21 AM
```You're welcome Scudo.................
My formulas were just basic IF statements,  =IF(I8=1,150,IF(I8=2,125,"")) in
M7 .....(IF I8 equals 1, then return 150, otherwise, IF I8 equals  2, then
return 125 otherwise leave the cell blank.)

and =IF(I8=2,125,"") in M8.....(IF I8 equals 2, then return 125, otherwise
leave the cell blank)........

Both were then wrapped in TEXT statements to display the leading POUND
sign..."CHAR(163)".

If you wanted to do further math with the now TEXT results, you could strip
out the number part to multiply the result by 2 with...........
=MID(M7,FIND(CHAR(163),M7,1)+1,99)*2...which says, in M7, find the POUNDsign
and go to the back side of it " the +1", and take the next 99 characters and
multiply by 2.....of course there's only 3 more characters so it takes them
all.

And you can put the POUND sign back in with CONCATENATION.........

=CHAR(163)&MID(M7,FIND(CHAR(163),M7,1)+1,99)*2

Vaya con Dios,
Chuck, CABGx3

"Scudo" <me@nospam.fictional> wrote in message
news:PDFxe.335\$vF2.40@fe1.news.blueyonder.co.uk...
> Chuck and RD
>
> Clever! `It works` and for the life of me I can`t (couldn`t ever never,
old
> time! or  new time!) understand either of them.  I look at the formulas
and
> try and work out how they work. I don`t know what they feed you guys on
but
> it sure seems to work, keep eating the stuff :-)
>
> and thanks for your help
> really do appreciate it.
>
> Scudo
>
>
> "CLR" <croberts@tampabay.rr.com> wrote in message
> news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> > That's very clever RD........I've never seen it done like that.
> >
> > I would have just used the old time
> > =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in M7
> > and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > > Try this:
> > >
> > > In M7:
> > > =(I8=1)*150+125*(I8=2)
> > >
> > > In M8:
> > > =125*(I8=2)
> > > --
> > >
> > > HTH,
> > >
> > > RD
> > > ==============================================
> > > Please keep all correspondence within the Group, so all may benefit!
> > > ==============================================
> > >
> > > "Scudo" <me@nospam.fictional> wrote in message
> > > news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > > In cell I8 I put a 1 or 2
> > > If I put 1 then I want cell M7 tp show �150
> > > If I put 2 then i want cell M7 to show �125 and cell M8 to show �125
> > >
> > > As a variation if its easier I would be happy with cell I8
> > > If I put 1 then I want cell M7 tp show �150
> > > If I put 2 then i want cell M8 to show �100,   as either way it would
> show
> > a
> > > total of �250
> > >
> > >
> > > thanks
> > >
> > >
> > >
> >
> >
>
>

```
 0
croberts (1377)
7/3/2005 4:07:36 PM
```Thanks CLR I have printed your reply and gonna spend some time trying to
understand and play with it,  It used to be easier when I was a lot younger
now its enjoyable but frustrating, I love doing spreadsheet stuff but the
brain aint what it used to be..ooooo to be young again. :-)

"CLR" <croberts@tampabay.rr.com> wrote in message
news:eILbBl#fFHA.2444@tk2msftngp13.phx.gbl...
> You're welcome Scudo.................
> My formulas were just basic IF statements,  =IF(I8=1,150,IF(I8=2,125,""))
in
> M7 .....(IF I8 equals 1, then return 150, otherwise, IF I8 equals  2, then
> return 125 otherwise leave the cell blank.)
>
> and =IF(I8=2,125,"") in M8.....(IF I8 equals 2, then return 125, otherwise
> leave the cell blank)........
>
> Both were then wrapped in TEXT statements to display the leading POUND
> sign..."CHAR(163)".
>
> If you wanted to do further math with the now TEXT results, you could
strip
> out the number part to multiply the result by 2 with...........
> =MID(M7,FIND(CHAR(163),M7,1)+1,99)*2...which says, in M7, find the
POUNDsign
> and go to the back side of it " the +1", and take the next 99 characters
and
> multiply by 2.....of course there's only 3 more characters so it takes
them
> all.
>
> And you can put the POUND sign back in with CONCATENATION.........
>
> =CHAR(163)&MID(M7,FIND(CHAR(163),M7,1)+1,99)*2
>
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Scudo" <me@nospam.fictional> wrote in message
> news:PDFxe.335\$vF2.40@fe1.news.blueyonder.co.uk...
> > Chuck and RD
> >
> > Clever! `It works` and for the life of me I can`t (couldn`t ever never,
> old
> > time! or  new time!) understand either of them.  I look at the formulas
> and
> > try and work out how they work. I don`t know what they feed you guys on
> but
> > it sure seems to work, keep eating the stuff :-)
> >
> > and thanks for your help
> > really do appreciate it.
> >
> > Scudo
> >
> >
> > "CLR" <croberts@tampabay.rr.com> wrote in message
> > news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> > > That's very clever RD........I've never seen it done like that.
> > >
> > > I would have just used the old time
> > > =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in M7
> > > and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
> > >
> > > Vaya con Dios,
> > > Chuck, CABGx3
> > >
> > >
> > >
> > > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > > news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > > > Try this:
> > > >
> > > > In M7:
> > > > =(I8=1)*150+125*(I8=2)
> > > >
> > > > In M8:
> > > > =125*(I8=2)
> > > > --
> > > >
> > > > HTH,
> > > >
> > > > RD
> > > > ==============================================
> > > > Please keep all correspondence within the Group, so all may benefit!
> > > > ==============================================
> > > >
> > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > > > In cell I8 I put a 1 or 2
> > > > If I put 1 then I want cell M7 tp show �150
> > > > If I put 2 then i want cell M7 to show �125 and cell M8 to show �125
> > > >
> > > > As a variation if its easier I would be happy with cell I8
> > > > If I put 1 then I want cell M7 tp show �150
> > > > If I put 2 then i want cell M8 to show �100,   as either way it
would
> > show
> > > a
> > > > total of �250
> > > >
> > > >
> > > > thanks
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

```
 0
me6808 (48)
7/3/2005 10:11:11 PM
```I hear ya Scudo...........I'll turn 67 in September.  I had done a little
Symphony stuff before, but never really started into this stuff strong until
after my Triple Bypass.......and I figured at that point, "what the
he**".........give it a go, and it's been loads of fun.  I tell you tho,
like most things, I really have to keep after it all the time or it gets
away from me.....but I''ll tell you one thing, I do learn something new
every day here, and really enjoy the experience of both learning something
myself, and helping other people where I can.........keep coming back Scudo,
keep reading the newsgroup and you'll soon be responding..........you got
the bug.......

Vaya con Dios,
Chuck, CABGx3

"Scudo" <me@nospam.fictional> wrote in message
news:3oZxe.67633\$Vo6.36687@fe3.news.blueyonder.co.uk...
> Thanks CLR I have printed your reply and gonna spend some time trying to
> understand and play with it,  It used to be easier when I was a lot
younger
> now its enjoyable but frustrating, I love doing spreadsheet stuff but the
> brain aint what it used to be..ooooo to be young again. :-)
>
>
> "CLR" <croberts@tampabay.rr.com> wrote in message
> news:eILbBl#fFHA.2444@tk2msftngp13.phx.gbl...
> > You're welcome Scudo.................
> > My formulas were just basic IF statements,
=IF(I8=1,150,IF(I8=2,125,""))
> in
> > M7 .....(IF I8 equals 1, then return 150, otherwise, IF I8 equals  2,
then
> > return 125 otherwise leave the cell blank.)
> >
> > and =IF(I8=2,125,"") in M8.....(IF I8 equals 2, then return 125,
otherwise
> > leave the cell blank)........
> >
> > Both were then wrapped in TEXT statements to display the leading POUND
> > sign..."CHAR(163)".
> >
> > If you wanted to do further math with the now TEXT results, you could
> strip
> > out the number part to multiply the result by 2 with...........
> > =MID(M7,FIND(CHAR(163),M7,1)+1,99)*2...which says, in M7, find the
> POUNDsign
> > and go to the back side of it " the +1", and take the next 99 characters
> and
> > multiply by 2.....of course there's only 3 more characters so it takes
> them
> > all.
> >
> > And you can put the POUND sign back in with CONCATENATION.........
> >
> > =CHAR(163)&MID(M7,FIND(CHAR(163),M7,1)+1,99)*2
> >
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "Scudo" <me@nospam.fictional> wrote in message
> > news:PDFxe.335\$vF2.40@fe1.news.blueyonder.co.uk...
> > > Chuck and RD
> > >
> > > Clever! `It works` and for the life of me I can`t (couldn`t ever
never,
> > old
> > > time! or  new time!) understand either of them.  I look at the
formulas
> > and
> > > try and work out how they work. I don`t know what they feed you guys
on
> > but
> > > it sure seems to work, keep eating the stuff :-)
> > >
> > > and thanks for your help
> > > really do appreciate it.
> > >
> > > Scudo
> > >
> > >
> > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> > > > That's very clever RD........I've never seen it done like that.
> > > >
> > > > I would have just used the old time
> > > > =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in M7
> > > > and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
> > > >
> > > > Vaya con Dios,
> > > > Chuck, CABGx3
> > > >
> > > >
> > > >
> > > > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > > > news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > > > > Try this:
> > > > >
> > > > > In M7:
> > > > > =(I8=1)*150+125*(I8=2)
> > > > >
> > > > > In M8:
> > > > > =125*(I8=2)
> > > > > --
> > > > >
> > > > > HTH,
> > > > >
> > > > > RD
> > > > > ==============================================
> > > > > Please keep all correspondence within the Group, so all may
benefit!
> > > > > ==============================================
> > > > >
> > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > > > > In cell I8 I put a 1 or 2
> > > > > If I put 1 then I want cell M7 tp show �150
> > > > > If I put 2 then i want cell M7 to show �125 and cell M8 to show
�125
> > > > >
> > > > > As a variation if its easier I would be happy with cell I8
> > > > > If I put 1 then I want cell M7 tp show �150
> > > > > If I put 2 then i want cell M8 to show �100,   as either way it
> would
> > > show
> > > > a
> > > > > total of �250
> > > > >
> > > > >
> > > > > thanks
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

```
 0
croberts (1377)
7/3/2005 11:35:03 PM
```Well I'll be darned ... you are old!<g>

I'm November of '38.

AND, what they say IS TRUE.

It's NOT how old you are, but how old you FEEL.

Also, these groups help delay the Alzheimers, keeping the brain exercising.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"CLR" <croberts@tampabay.rr.com> wrote in message
news:eSckDfCgFHA.4032@TK2MSFTNGP10.phx.gbl...
> I hear ya Scudo...........I'll turn 67 in September.  I had done a little
> Symphony stuff before, but never really started into this stuff strong
until
> after my Triple Bypass.......and I figured at that point, "what the
> he**".........give it a go, and it's been loads of fun.  I tell you tho,
> like most things, I really have to keep after it all the time or it gets
> away from me.....but I''ll tell you one thing, I do learn something new
> every day here, and really enjoy the experience of both learning something
> myself, and helping other people where I can.........keep coming back
Scudo,
> keep reading the newsgroup and you'll soon be responding..........you got
> the bug.......
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
>
>
> "Scudo" <me@nospam.fictional> wrote in message
> news:3oZxe.67633\$Vo6.36687@fe3.news.blueyonder.co.uk...
> > Thanks CLR I have printed your reply and gonna spend some time trying to
> > understand and play with it,  It used to be easier when I was a lot
> younger
> > now its enjoyable but frustrating, I love doing spreadsheet stuff but
the
> > brain aint what it used to be..ooooo to be young again. :-)
> >
> >
> > "CLR" <croberts@tampabay.rr.com> wrote in message
> > news:eILbBl#fFHA.2444@tk2msftngp13.phx.gbl...
> > > You're welcome Scudo.................
> > > My formulas were just basic IF statements,
> =IF(I8=1,150,IF(I8=2,125,""))
> > in
> > > M7 .....(IF I8 equals 1, then return 150, otherwise, IF I8 equals  2,
> then
> > > return 125 otherwise leave the cell blank.)
> > >
> > > and =IF(I8=2,125,"") in M8.....(IF I8 equals 2, then return 125,
> otherwise
> > > leave the cell blank)........
> > >
> > > Both were then wrapped in TEXT statements to display the leading POUND
> > > sign..."CHAR(163)".
> > >
> > > If you wanted to do further math with the now TEXT results, you could
> > strip
> > > out the number part to multiply the result by 2 with...........
> > > =MID(M7,FIND(CHAR(163),M7,1)+1,99)*2...which says, in M7, find the
> > POUNDsign
> > > and go to the back side of it " the +1", and take the next 99
characters
> > and
> > > multiply by 2.....of course there's only 3 more characters so it takes
> > them
> > > all.
> > >
> > > And you can put the POUND sign back in with CONCATENATION.........
> > >
> > > =CHAR(163)&MID(M7,FIND(CHAR(163),M7,1)+1,99)*2
> > >
> > >
> > > Vaya con Dios,
> > > Chuck, CABGx3
> > >
> > >
> > >
> > > "Scudo" <me@nospam.fictional> wrote in message
> > > news:PDFxe.335\$vF2.40@fe1.news.blueyonder.co.uk...
> > > > Chuck and RD
> > > >
> > > > Clever! `It works` and for the life of me I can`t (couldn`t ever
> never,
> > > old
> > > > time! or  new time!) understand either of them.  I look at the
> formulas
> > > and
> > > > try and work out how they work. I don`t know what they feed you guys
> on
> > > but
> > > > it sure seems to work, keep eating the stuff :-)
> > > >
> > > > and thanks for your help
> > > > really do appreciate it.
> > > >
> > > > Scudo
> > > >
> > > >
> > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> > > > > That's very clever RD........I've never seen it done like that.
> > > > >
> > > > > I would have just used the old time
> > > > > =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in M7
> > > > > and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
> > > > >
> > > > > Vaya con Dios,
> > > > > Chuck, CABGx3
> > > > >
> > > > >
> > > > >
> > > > > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > > > > news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > > > > > Try this:
> > > > > >
> > > > > > In M7:
> > > > > > =(I8=1)*150+125*(I8=2)
> > > > > >
> > > > > > In M8:
> > > > > > =125*(I8=2)
> > > > > > --
> > > > > >
> > > > > > HTH,
> > > > > >
> > > > > > RD
> > > > > > ==============================================
> > > > > > Please keep all correspondence within the Group, so all may
> benefit!
> > > > > > ==============================================
> > > > > >
> > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > > > > > In cell I8 I put a 1 or 2
> > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > If I put 2 then i want cell M7 to show �125 and cell M8 to show
> �125
> > > > > >
> > > > > > As a variation if its easier I would be happy with cell I8
> > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > If I put 2 then i want cell M8 to show �100,   as either way it
> > would
> > > > show
> > > > > a
> > > > > > total of �250
> > > > > >
> > > > > >
> > > > > > thanks
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

```
 0
ragdyer1 (4060)
7/5/2005 10:14:49 PM
```Beat you all at 69 (favorite number) on income tax day.

--
Don Guillett
SalesAid Software
donaldb@281.com
"RagDyer" <RagDyer@cutoutmsn.com> wrote in message
news:%234aAA8agFHA.2644@TK2MSFTNGP09.phx.gbl...
> Well I'll be darned ... you are old!<g>
>
> I'm November of '38.
>
> AND, what they say IS TRUE.
>
> It's NOT how old you are, but how old you FEEL.
>
> Also, these groups help delay the Alzheimers, keeping the brain
exercising.
> --
> Regards,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
>
> "CLR" <croberts@tampabay.rr.com> wrote in message
> news:eSckDfCgFHA.4032@TK2MSFTNGP10.phx.gbl...
> > I hear ya Scudo...........I'll turn 67 in September.  I had done a
little
> > Symphony stuff before, but never really started into this stuff strong
> until
> > after my Triple Bypass.......and I figured at that point, "what the
> > he**".........give it a go, and it's been loads of fun.  I tell you tho,
> > like most things, I really have to keep after it all the time or it gets
> > away from me.....but I''ll tell you one thing, I do learn something new
> > every day here, and really enjoy the experience of both learning
something
> > myself, and helping other people where I can.........keep coming back
> Scudo,
> > keep reading the newsgroup and you'll soon be responding..........you
got
> > the bug.......
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> >
> >
> >
> > "Scudo" <me@nospam.fictional> wrote in message
> > news:3oZxe.67633\$Vo6.36687@fe3.news.blueyonder.co.uk...
> > > Thanks CLR I have printed your reply and gonna spend some time trying
to
> > > understand and play with it,  It used to be easier when I was a lot
> > younger
> > > now its enjoyable but frustrating, I love doing spreadsheet stuff but
> the
> > > brain aint what it used to be..ooooo to be young again. :-)
> > >
> > >
> > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > news:eILbBl#fFHA.2444@tk2msftngp13.phx.gbl...
> > > > You're welcome Scudo.................
> > > > My formulas were just basic IF statements,
> > =IF(I8=1,150,IF(I8=2,125,""))
> > > in
> > > > M7 .....(IF I8 equals 1, then return 150, otherwise, IF I8 equals
2,
> > then
> > > > return 125 otherwise leave the cell blank.)
> > > >
> > > > and =IF(I8=2,125,"") in M8.....(IF I8 equals 2, then return 125,
> > otherwise
> > > > leave the cell blank)........
> > > >
> > > > Both were then wrapped in TEXT statements to display the leading
POUND
> > > > sign..."CHAR(163)".
> > > >
> > > > If you wanted to do further math with the now TEXT results, you
could
> > > strip
> > > > out the number part to multiply the result by 2 with...........
> > > > =MID(M7,FIND(CHAR(163),M7,1)+1,99)*2...which says, in M7, find the
> > > POUNDsign
> > > > and go to the back side of it " the +1", and take the next 99
> characters
> > > and
> > > > multiply by 2.....of course there's only 3 more characters so it
takes
> > > them
> > > > all.
> > > >
> > > > And you can put the POUND sign back in with CONCATENATION.........
> > > >
> > > > =CHAR(163)&MID(M7,FIND(CHAR(163),M7,1)+1,99)*2
> > > >
> > > >
> > > > Vaya con Dios,
> > > > Chuck, CABGx3
> > > >
> > > >
> > > >
> > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > news:PDFxe.335\$vF2.40@fe1.news.blueyonder.co.uk...
> > > > > Chuck and RD
> > > > >
> > > > > Clever! `It works` and for the life of me I can`t (couldn`t ever
> > never,
> > > > old
> > > > > time! or  new time!) understand either of them.  I look at the
> > formulas
> > > > and
> > > > > try and work out how they work. I don`t know what they feed you
guys
> > on
> > > > but
> > > > > it sure seems to work, keep eating the stuff :-)
> > > > >
> > > > > and thanks for your help
> > > > > really do appreciate it.
> > > > >
> > > > > Scudo
> > > > >
> > > > >
> > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> > > > > > That's very clever RD........I've never seen it done like that.
> > > > > >
> > > > > > I would have just used the old time
> > > > > > =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in M7
> > > > > > and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
> > > > > >
> > > > > > Vaya con Dios,
> > > > > > Chuck, CABGx3
> > > > > >
> > > > > >
> > > > > >
> > > > > > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > > > > > news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > > > > > > Try this:
> > > > > > >
> > > > > > > In M7:
> > > > > > > =(I8=1)*150+125*(I8=2)
> > > > > > >
> > > > > > > In M8:
> > > > > > > =125*(I8=2)
> > > > > > > --
> > > > > > >
> > > > > > > HTH,
> > > > > > >
> > > > > > > RD
> > > > > > > ==============================================
> > > > > > > Please keep all correspondence within the Group, so all may
> > benefit!
> > > > > > > ==============================================
> > > > > > >
> > > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > > news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > > > > > > In cell I8 I put a 1 or 2
> > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > If I put 2 then i want cell M7 to show �125 and cell M8 to
show
> > �125
> > > > > > >
> > > > > > > As a variation if its easier I would be happy with cell I8
> > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > If I put 2 then i want cell M8 to show �100,   as either way
it
> > > would
> > > > > show
> > > > > > a
> > > > > > > total of �250
> > > > > > >
> > > > > > >
> > > > > > > thanks
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

```
 0
Don
7/6/2005 12:07:38 AM
```And I thought that I was associating with a bunch of whiz kids! <g>

--

Sandy
sandymann@mailinator.com
Replace@mailinator with @tiscali.co.uk

"Don Guillett" <donaldb@281.com> wrote in message
news:#v2056bgFHA.2904@tk2msftngp13.phx.gbl...
> Beat you all at 69 (favorite number) on income tax day.
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "RagDyer" <RagDyer@cutoutmsn.com> wrote in message
> news:%234aAA8agFHA.2644@TK2MSFTNGP09.phx.gbl...
> > Well I'll be darned ... you are old!<g>
> >
> > I'm November of '38.
> >
> > AND, what they say IS TRUE.
> >
> > It's NOT how old you are, but how old you FEEL.
> >
> > Also, these groups help delay the Alzheimers, keeping the brain
> exercising.
> > --
> > Regards,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
> -
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
> -
> >
> > "CLR" <croberts@tampabay.rr.com> wrote in message
> > news:eSckDfCgFHA.4032@TK2MSFTNGP10.phx.gbl...
> > > I hear ya Scudo...........I'll turn 67 in September.  I had done a
> little
> > > Symphony stuff before, but never really started into this stuff strong
> > until
> > > after my Triple Bypass.......and I figured at that point, "what the
> > > he**".........give it a go, and it's been loads of fun.  I tell you
tho,
> > > like most things, I really have to keep after it all the time or it
gets
> > > away from me.....but I''ll tell you one thing, I do learn something
new
> > > every day here, and really enjoy the experience of both learning
> something
> > > myself, and helping other people where I can.........keep coming back
> > Scudo,
> > > keep reading the newsgroup and you'll soon be responding..........you
> got
> > > the bug.......
> > >
> > > Vaya con Dios,
> > > Chuck, CABGx3
> > >
> > >
> > >
> > >
> > >
> > >
> > > "Scudo" <me@nospam.fictional> wrote in message
> > > news:3oZxe.67633\$Vo6.36687@fe3.news.blueyonder.co.uk...
> > > > Thanks CLR I have printed your reply and gonna spend some time
trying
> to
> > > > understand and play with it,  It used to be easier when I was a lot
> > > younger
> > > > now its enjoyable but frustrating, I love doing spreadsheet stuff
but
> > the
> > > > brain aint what it used to be..ooooo to be young again. :-)
> > > >
> > > >
> > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > news:eILbBl#fFHA.2444@tk2msftngp13.phx.gbl...
> > > > > You're welcome Scudo.................
> > > > > My formulas were just basic IF statements,
> > > =IF(I8=1,150,IF(I8=2,125,""))
> > > > in
> > > > > M7 .....(IF I8 equals 1, then return 150, otherwise, IF I8 equals
> 2,
> > > then
> > > > > return 125 otherwise leave the cell blank.)
> > > > >
> > > > > and =IF(I8=2,125,"") in M8.....(IF I8 equals 2, then return 125,
> > > otherwise
> > > > > leave the cell blank)........
> > > > >
> > > > > Both were then wrapped in TEXT statements to display the leading
> POUND
> > > > > sign..."CHAR(163)".
> > > > >
> > > > > If you wanted to do further math with the now TEXT results, you
> could
> > > > strip
> > > > > out the number part to multiply the result by 2 with...........
> > > > > =MID(M7,FIND(CHAR(163),M7,1)+1,99)*2...which says, in M7, find the
> > > > POUNDsign
> > > > > and go to the back side of it " the +1", and take the next 99
> > characters
> > > > and
> > > > > multiply by 2.....of course there's only 3 more characters so it
> takes
> > > > them
> > > > > all.
> > > > >
> > > > > And you can put the POUND sign back in with CONCATENATION.........
> > > > >
> > > > > =CHAR(163)&MID(M7,FIND(CHAR(163),M7,1)+1,99)*2
> > > > >
> > > > >
> > > > > Vaya con Dios,
> > > > > Chuck, CABGx3
> > > > >
> > > > >
> > > > >
> > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > news:PDFxe.335\$vF2.40@fe1.news.blueyonder.co.uk...
> > > > > > Chuck and RD
> > > > > >
> > > > > > Clever! `It works` and for the life of me I can`t (couldn`t ever
> > > never,
> > > > > old
> > > > > > time! or  new time!) understand either of them.  I look at the
> > > formulas
> > > > > and
> > > > > > try and work out how they work. I don`t know what they feed you
> guys
> > > on
> > > > > but
> > > > > > it sure seems to work, keep eating the stuff :-)
> > > > > >
> > > > > > and thanks for your help
> > > > > > really do appreciate it.
> > > > > >
> > > > > > Scudo
> > > > > >
> > > > > >
> > > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > > news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> > > > > > > That's very clever RD........I've never seen it done like
that.
> > > > > > >
> > > > > > > I would have just used the old time
> > > > > > > =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in M7
> > > > > > > and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
> > > > > > >
> > > > > > > Vaya con Dios,
> > > > > > > Chuck, CABGx3
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > > > > > > news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > > > > > > > Try this:
> > > > > > > >
> > > > > > > > In M7:
> > > > > > > > =(I8=1)*150+125*(I8=2)
> > > > > > > >
> > > > > > > > In M8:
> > > > > > > > =125*(I8=2)
> > > > > > > > --
> > > > > > > >
> > > > > > > > HTH,
> > > > > > > >
> > > > > > > > RD
> > > > > > > > ==============================================
> > > > > > > > Please keep all correspondence within the Group, so all may
> > > benefit!
> > > > > > > > ==============================================
> > > > > > > >
> > > > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > > > news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > > > > > > > In cell I8 I put a 1 or 2
> > > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > > If I put 2 then i want cell M7 to show �125 and cell M8 to
> show
> > > �125
> > > > > > > >
> > > > > > > > As a variation if its easier I would be happy with cell I8
> > > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > > If I put 2 then i want cell M8 to show �100,   as either way
> it
> > > > would
> > > > > > show
> > > > > > > a
> > > > > > > > total of �250
> > > > > > > >
> > > > > > > >
> > > > > > > > thanks
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
>
>

```
 0
sandymann2 (1054)
7/6/2005 7:23:20 PM
```..........and your point is?............<VBG>

Vaya con Dios,
Chuck, CABGx3

"Sandy Mann" <sandymann2@mailinator.com> wrote in message
news:OJq7HFmgFHA.2548@TK2MSFTNGP10.phx.gbl...
> And I thought that I was associating with a bunch of whiz kids! <g>
>
> --
>
> Sandy
> sandymann@mailinator.com
> Replace@mailinator with @tiscali.co.uk
>
>
> "Don Guillett" <donaldb@281.com> wrote in message
> news:#v2056bgFHA.2904@tk2msftngp13.phx.gbl...
> > Beat you all at 69 (favorite number) on income tax day.
> >
> > --
> > Don Guillett
> > SalesAid Software
> > donaldb@281.com
> > "RagDyer" <RagDyer@cutoutmsn.com> wrote in message
> > news:%234aAA8agFHA.2644@TK2MSFTNGP09.phx.gbl...
> > > Well I'll be darned ... you are old!<g>
> > >
> > > I'm November of '38.
> > >
> > > AND, what they say IS TRUE.
> > >
> > > It's NOT how old you are, but how old you FEEL.
> > >
> > > Also, these groups help delay the Alzheimers, keeping the brain
> > exercising.
> > > --
> > > Regards,
> > >
> > > RD
> > >
> >
>
> --------------------------------------------------------------------------
> > -
> > > Please keep all correspondence within the NewsGroup, so all may
benefit
> !
> >
>
> --------------------------------------------------------------------------
> > -
> > >
> > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > news:eSckDfCgFHA.4032@TK2MSFTNGP10.phx.gbl...
> > > > I hear ya Scudo...........I'll turn 67 in September.  I had done a
> > little
> > > > Symphony stuff before, but never really started into this stuff
strong
> > > until
> > > > after my Triple Bypass.......and I figured at that point, "what the
> > > > he**".........give it a go, and it's been loads of fun.  I tell you
> tho,
> > > > like most things, I really have to keep after it all the time or it
> gets
> > > > away from me.....but I''ll tell you one thing, I do learn something
> new
> > > > every day here, and really enjoy the experience of both learning
> > something
> > > > myself, and helping other people where I can.........keep coming
back
> > > Scudo,
> > > > keep reading the newsgroup and you'll soon be
responding..........you
> > got
> > > > the bug.......
> > > >
> > > > Vaya con Dios,
> > > > Chuck, CABGx3
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > news:3oZxe.67633\$Vo6.36687@fe3.news.blueyonder.co.uk...
> > > > > Thanks CLR I have printed your reply and gonna spend some time
> trying
> > to
> > > > > understand and play with it,  It used to be easier when I was a
lot
> > > > younger
> > > > > now its enjoyable but frustrating, I love doing spreadsheet stuff
> but
> > > the
> > > > > brain aint what it used to be..ooooo to be young again. :-)
> > > > >
> > > > >
> > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > news:eILbBl#fFHA.2444@tk2msftngp13.phx.gbl...
> > > > > > You're welcome Scudo.................
> > > > > > My formulas were just basic IF statements,
> > > > =IF(I8=1,150,IF(I8=2,125,""))
> > > > > in
> > > > > > M7 .....(IF I8 equals 1, then return 150, otherwise, IF I8
equals
> > 2,
> > > > then
> > > > > > return 125 otherwise leave the cell blank.)
> > > > > >
> > > > > > and =IF(I8=2,125,"") in M8.....(IF I8 equals 2, then return 125,
> > > > otherwise
> > > > > > leave the cell blank)........
> > > > > >
> > > > > > Both were then wrapped in TEXT statements to display the leading
> > POUND
> > > > > > sign..."CHAR(163)".
> > > > > >
> > > > > > If you wanted to do further math with the now TEXT results, you
> > could
> > > > > strip
> > > > > > out the number part to multiply the result by 2 with...........
> > > > > > =MID(M7,FIND(CHAR(163),M7,1)+1,99)*2...which says, in M7, find
the
> > > > > POUNDsign
> > > > > > and go to the back side of it " the +1", and take the next 99
> > > characters
> > > > > and
> > > > > > multiply by 2.....of course there's only 3 more characters so it
> > takes
> > > > > them
> > > > > > all.
> > > > > >
> > > > > > And you can put the POUND sign back in with
CONCATENATION.........
> > > > > >
> > > > > > =CHAR(163)&MID(M7,FIND(CHAR(163),M7,1)+1,99)*2
> > > > > >
> > > > > >
> > > > > > Vaya con Dios,
> > > > > > Chuck, CABGx3
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > news:PDFxe.335\$vF2.40@fe1.news.blueyonder.co.uk...
> > > > > > > Chuck and RD
> > > > > > >
> > > > > > > Clever! `It works` and for the life of me I can`t (couldn`t
ever
> > > > never,
> > > > > > old
> > > > > > > time! or  new time!) understand either of them.  I look at the
> > > > formulas
> > > > > > and
> > > > > > > try and work out how they work. I don`t know what they feed
you
> > guys
> > > > on
> > > > > > but
> > > > > > > it sure seems to work, keep eating the stuff :-)
> > > > > > >
> > > > > > > and thanks for your help
> > > > > > > really do appreciate it.
> > > > > > >
> > > > > > > Scudo
> > > > > > >
> > > > > > >
> > > > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > > > news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> > > > > > > > That's very clever RD........I've never seen it done like
> that.
> > > > > > > >
> > > > > > > > I would have just used the old time
> > > > > > > > =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in M7
> > > > > > > > and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
> > > > > > > >
> > > > > > > > Vaya con Dios,
> > > > > > > > Chuck, CABGx3
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > > > > > > > news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > > > > > > > > Try this:
> > > > > > > > >
> > > > > > > > > In M7:
> > > > > > > > > =(I8=1)*150+125*(I8=2)
> > > > > > > > >
> > > > > > > > > In M8:
> > > > > > > > > =125*(I8=2)
> > > > > > > > > --
> > > > > > > > >
> > > > > > > > > HTH,
> > > > > > > > >
> > > > > > > > > RD
> > > > > > > > > ==============================================
> > > > > > > > > Please keep all correspondence within the Group, so all
may
> > > > benefit!
> > > > > > > > > ==============================================
> > > > > > > > >
> > > > > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > > > > news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > > > > > > > > In cell I8 I put a 1 or 2
> > > > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > > > If I put 2 then i want cell M7 to show �125 and cell M8 to
> > show
> > > > �125
> > > > > > > > >
> > > > > > > > > As a variation if its easier I would be happy with cell I8
> > > > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > > > If I put 2 then i want cell M8 to show �100,   as either
way
> > it
> > > > > would
> > > > > > > show
> > > > > > > > a
> > > > > > > > > total of �250
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > thanks
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
>

```
 0
croberts (1377)
7/6/2005 8:14:48 PM
```Well, I'm just a youngster at 63......

--

Sandy
sandymann@mailinator.com
Replace@mailinator with @tiscali.co.uk

"CLR" <croberts@tampabay.rr.com> wrote in message
news:uio7GdmgFHA.3868@TK2MSFTNGP14.phx.gbl...
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Sandy Mann" <sandymann2@mailinator.com> wrote in message
> news:OJq7HFmgFHA.2548@TK2MSFTNGP10.phx.gbl...
> > And I thought that I was associating with a bunch of whiz kids! <g>
> >
> > --
> >
> > Sandy
> > sandymann@mailinator.com
> > Replace@mailinator with @tiscali.co.uk
> >
> >
> > "Don Guillett" <donaldb@281.com> wrote in message
> > news:#v2056bgFHA.2904@tk2msftngp13.phx.gbl...
> > > Beat you all at 69 (favorite number) on income tax day.
> > >
> > > --
> > > Don Guillett
> > > SalesAid Software
> > > donaldb@281.com
> > > "RagDyer" <RagDyer@cutoutmsn.com> wrote in message
> > > news:%234aAA8agFHA.2644@TK2MSFTNGP09.phx.gbl...
> > > > Well I'll be darned ... you are old!<g>
> > > >
> > > > I'm November of '38.
> > > >
> > > > AND, what they say IS TRUE.
> > > >
> > > > It's NOT how old you are, but how old you FEEL.
> > > >
> > > > Also, these groups help delay the Alzheimers, keeping the brain
> > > exercising.
> > > > --
> > > > Regards,
> > > >
> > > > RD
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > -
> > > > Please keep all correspondence within the NewsGroup, so all may
> benefit
> > !
> > >
> >
>
> --------------------------------------------------------------------------
> > > -
> > > >
> > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > news:eSckDfCgFHA.4032@TK2MSFTNGP10.phx.gbl...
> > > > > I hear ya Scudo...........I'll turn 67 in September.  I had done a
> > > little
> > > > > Symphony stuff before, but never really started into this stuff
> strong
> > > > until
> > > > > after my Triple Bypass.......and I figured at that point, "what
the
> > > > > he**".........give it a go, and it's been loads of fun.  I tell
you
> > tho,
> > > > > like most things, I really have to keep after it all the time or
it
> > gets
> > > > > away from me.....but I''ll tell you one thing, I do learn
something
> > new
> > > > > every day here, and really enjoy the experience of both learning
> > > something
> > > > > myself, and helping other people where I can.........keep coming
> back
> > > > Scudo,
> > > > > keep reading the newsgroup and you'll soon be
> responding..........you
> > > got
> > > > > the bug.......
> > > > >
> > > > > Vaya con Dios,
> > > > > Chuck, CABGx3
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > news:3oZxe.67633\$Vo6.36687@fe3.news.blueyonder.co.uk...
> > > > > > Thanks CLR I have printed your reply and gonna spend some time
> > trying
> > > to
> > > > > > understand and play with it,  It used to be easier when I was a
> lot
> > > > > younger
> > > > > > now its enjoyable but frustrating, I love doing spreadsheet
stuff
> > but
> > > > the
> > > > > > brain aint what it used to be..ooooo to be young again. :-)
> > > > > >
> > > > > >
> > > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > > news:eILbBl#fFHA.2444@tk2msftngp13.phx.gbl...
> > > > > > > You're welcome Scudo.................
> > > > > > > My formulas were just basic IF statements,
> > > > > =IF(I8=1,150,IF(I8=2,125,""))
> > > > > > in
> > > > > > > M7 .....(IF I8 equals 1, then return 150, otherwise, IF I8
> equals
> > > 2,
> > > > > then
> > > > > > > return 125 otherwise leave the cell blank.)
> > > > > > >
> > > > > > > and =IF(I8=2,125,"") in M8.....(IF I8 equals 2, then return
125,
> > > > > otherwise
> > > > > > > leave the cell blank)........
> > > > > > >
> > > > > > > Both were then wrapped in TEXT statements to display the
> > > POUND
> > > > > > > sign..."CHAR(163)".
> > > > > > >
> > > > > > > If you wanted to do further math with the now TEXT results,
you
> > > could
> > > > > > strip
> > > > > > > out the number part to multiply the result by 2
with...........
> > > > > > > =MID(M7,FIND(CHAR(163),M7,1)+1,99)*2...which says, in M7, find
> the
> > > > > > POUNDsign
> > > > > > > and go to the back side of it " the +1", and take the next 99
> > > > characters
> > > > > > and
> > > > > > > multiply by 2.....of course there's only 3 more characters so
it
> > > takes
> > > > > > them
> > > > > > > all.
> > > > > > >
> > > > > > > And you can put the POUND sign back in with
> CONCATENATION.........
> > > > > > >
> > > > > > > =CHAR(163)&MID(M7,FIND(CHAR(163),M7,1)+1,99)*2
> > > > > > >
> > > > > > >
> > > > > > > Vaya con Dios,
> > > > > > > Chuck, CABGx3
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > > news:PDFxe.335\$vF2.40@fe1.news.blueyonder.co.uk...
> > > > > > > > Chuck and RD
> > > > > > > >
> > > > > > > > Clever! `It works` and for the life of me I can`t (couldn`t
> ever
> > > > > never,
> > > > > > > old
> > > > > > > > time! or  new time!) understand either of them.  I look at
the
> > > > > formulas
> > > > > > > and
> > > > > > > > try and work out how they work. I don`t know what they feed
> you
> > > guys
> > > > > on
> > > > > > > but
> > > > > > > > it sure seems to work, keep eating the stuff :-)
> > > > > > > >
> > > > > > > > and thanks for your help
> > > > > > > > really do appreciate it.
> > > > > > > >
> > > > > > > > Scudo
> > > > > > > >
> > > > > > > >
> > > > > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > > > > news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> > > > > > > > > That's very clever RD........I've never seen it done like
> > that.
> > > > > > > > >
> > > > > > > > > I would have just used the old time
> > > > > > > > > =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in M7
> > > > > > > > > and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
> > > > > > > > >
> > > > > > > > > Vaya con Dios,
> > > > > > > > > Chuck, CABGx3
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > > > > > > > > news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > > > > > > > > > Try this:
> > > > > > > > > >
> > > > > > > > > > In M7:
> > > > > > > > > > =(I8=1)*150+125*(I8=2)
> > > > > > > > > >
> > > > > > > > > > In M8:
> > > > > > > > > > =125*(I8=2)
> > > > > > > > > > --
> > > > > > > > > >
> > > > > > > > > > HTH,
> > > > > > > > > >
> > > > > > > > > > RD
> > > > > > > > > > ==============================================
> > > > > > > > > > Please keep all correspondence within the Group, so all
> may
> > > > > benefit!
> > > > > > > > > > ==============================================
> > > > > > > > > >
> > > > > > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > > > > > news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > > > > > > > > > In cell I8 I put a 1 or 2
> > > > > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > > > > If I put 2 then i want cell M7 to show �125 and cell M8
to
> > > show
> > > > > �125
> > > > > > > > > >
> > > > > > > > > > As a variation if its easier I would be happy with cell
I8
> > > > > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > > > > If I put 2 then i want cell M8 to show �100,   as either
> way
> > > it
> > > > > > would
> > > > > > > > show
> > > > > > > > > a
> > > > > > > > > > total of �250
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > thanks
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> >
>
>

```
 0
sandymann2 (1054)
7/6/2005 8:34:15 PM
```Wouldn't it knock your socks off if Harlan chimed in and said he was only
Jack Benny's age?

Only us "old" folks know what that was.<vbg>
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Sandy Mann" <sandymann2@mailinator.com> wrote in message
news:eTUaoymgFHA.3852@TK2MSFTNGP10.phx.gbl...
> Well, I'm just a youngster at 63......
>
> --
>
> Sandy
> sandymann@mailinator.com
> Replace@mailinator with @tiscali.co.uk
>
>
> "CLR" <croberts@tampabay.rr.com> wrote in message
> news:uio7GdmgFHA.3868@TK2MSFTNGP14.phx.gbl...
> > .........and your point is?............<VBG>
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "Sandy Mann" <sandymann2@mailinator.com> wrote in message
> > news:OJq7HFmgFHA.2548@TK2MSFTNGP10.phx.gbl...
> > > And I thought that I was associating with a bunch of whiz kids! <g>
> > >
> > > --
> > >
> > > Sandy
> > > sandymann@mailinator.com
> > > Replace@mailinator with @tiscali.co.uk
> > >
> > >
> > > "Don Guillett" <donaldb@281.com> wrote in message
> > > news:#v2056bgFHA.2904@tk2msftngp13.phx.gbl...
> > > > Beat you all at 69 (favorite number) on income tax day.
> > > >
> > > > --
> > > > Don Guillett
> > > > SalesAid Software
> > > > donaldb@281.com
> > > > "RagDyer" <RagDyer@cutoutmsn.com> wrote in message
> > > > news:%234aAA8agFHA.2644@TK2MSFTNGP09.phx.gbl...
> > > > > Well I'll be darned ... you are old!<g>
> > > > >
> > > > > I'm November of '38.
> > > > >
> > > > > AND, what they say IS TRUE.
> > > > >
> > > > > It's NOT how old you are, but how old you FEEL.
> > > > >
> > > > > Also, these groups help delay the Alzheimers, keeping the brain
> > > > exercising.
> > > > > --
> > > > > Regards,
> > > > >
> > > > > RD
> > > > >
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > > -
> > > > > Please keep all correspondence within the NewsGroup, so all may
> > benefit
> > > !
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > > -
> > > > >
> > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > news:eSckDfCgFHA.4032@TK2MSFTNGP10.phx.gbl...
> > > > > > I hear ya Scudo...........I'll turn 67 in September.  I had done
a
> > > > little
> > > > > > Symphony stuff before, but never really started into this stuff
> > strong
> > > > > until
> > > > > > after my Triple Bypass.......and I figured at that point, "what
> the
> > > > > > he**".........give it a go, and it's been loads of fun.  I tell
> you
> > > tho,
> > > > > > like most things, I really have to keep after it all the time or
> it
> > > gets
> > > > > > away from me.....but I''ll tell you one thing, I do learn
> something
> > > new
> > > > > > every day here, and really enjoy the experience of both learning
> > > > something
> > > > > > myself, and helping other people where I can.........keep coming
> > back
> > > > > Scudo,
> > > > > > keep reading the newsgroup and you'll soon be
> > responding..........you
> > > > got
> > > > > > the bug.......
> > > > > >
> > > > > > Vaya con Dios,
> > > > > > Chuck, CABGx3
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > news:3oZxe.67633\$Vo6.36687@fe3.news.blueyonder.co.uk...
> > > > > > > Thanks CLR I have printed your reply and gonna spend some time
> > > trying
> > > > to
> > > > > > > understand and play with it,  It used to be easier when I was
a
> > lot
> > > > > > younger
> > > > > > > now its enjoyable but frustrating, I love doing spreadsheet
> stuff
> > > but
> > > > > the
> > > > > > > brain aint what it used to be..ooooo to be young again. :-)
> > > > > > >
> > > > > > >
> > > > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > > > news:eILbBl#fFHA.2444@tk2msftngp13.phx.gbl...
> > > > > > > > You're welcome Scudo.................
> > > > > > > > My formulas were just basic IF statements,
> > > > > > =IF(I8=1,150,IF(I8=2,125,""))
> > > > > > > in
> > > > > > > > M7 .....(IF I8 equals 1, then return 150, otherwise, IF I8
> > equals
> > > > 2,
> > > > > > then
> > > > > > > > return 125 otherwise leave the cell blank.)
> > > > > > > >
> > > > > > > > and =IF(I8=2,125,"") in M8.....(IF I8 equals 2, then return
> 125,
> > > > > > otherwise
> > > > > > > > leave the cell blank)........
> > > > > > > >
> > > > > > > > Both were then wrapped in TEXT statements to display the
> > > > POUND
> > > > > > > > sign..."CHAR(163)".
> > > > > > > >
> > > > > > > > If you wanted to do further math with the now TEXT results,
> you
> > > > could
> > > > > > > strip
> > > > > > > > out the number part to multiply the result by 2
> with...........
> > > > > > > > =MID(M7,FIND(CHAR(163),M7,1)+1,99)*2...which says, in M7,
find
> > the
> > > > > > > POUNDsign
> > > > > > > > and go to the back side of it " the +1", and take the next
99
> > > > > characters
> > > > > > > and
> > > > > > > > multiply by 2.....of course there's only 3 more characters
so
> it
> > > > takes
> > > > > > > them
> > > > > > > > all.
> > > > > > > >
> > > > > > > > And you can put the POUND sign back in with
> > CONCATENATION.........
> > > > > > > >
> > > > > > > > =CHAR(163)&MID(M7,FIND(CHAR(163),M7,1)+1,99)*2
> > > > > > > >
> > > > > > > >
> > > > > > > > Vaya con Dios,
> > > > > > > > Chuck, CABGx3
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > > > news:PDFxe.335\$vF2.40@fe1.news.blueyonder.co.uk...
> > > > > > > > > Chuck and RD
> > > > > > > > >
> > > > > > > > > Clever! `It works` and for the life of me I can`t
(couldn`t
> > ever
> > > > > > never,
> > > > > > > > old
> > > > > > > > > time! or  new time!) understand either of them.  I look at
> the
> > > > > > formulas
> > > > > > > > and
> > > > > > > > > try and work out how they work. I don`t know what they
feed
> > you
> > > > guys
> > > > > > on
> > > > > > > > but
> > > > > > > > > it sure seems to work, keep eating the stuff :-)
> > > > > > > > >
> > > > > > > > > and thanks for your help
> > > > > > > > > really do appreciate it.
> > > > > > > > >
> > > > > > > > > Scudo
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > > > > > news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> > > > > > > > > > That's very clever RD........I've never seen it done
like
> > > that.
> > > > > > > > > >
> > > > > > > > > > I would have just used the old time
> > > > > > > > > > =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in
M7
> > > > > > > > > > and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
> > > > > > > > > >
> > > > > > > > > > Vaya con Dios,
> > > > > > > > > > Chuck, CABGx3
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > > > > > > > > > news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > > > > > > > > > > Try this:
> > > > > > > > > > >
> > > > > > > > > > > In M7:
> > > > > > > > > > > =(I8=1)*150+125*(I8=2)
> > > > > > > > > > >
> > > > > > > > > > > In M8:
> > > > > > > > > > > =125*(I8=2)
> > > > > > > > > > > --
> > > > > > > > > > >
> > > > > > > > > > > HTH,
> > > > > > > > > > >
> > > > > > > > > > > RD
> > > > > > > > > > > ==============================================
> > > > > > > > > > > Please keep all correspondence within the Group, so
all
> > may
> > > > > > benefit!
> > > > > > > > > > > ==============================================
> > > > > > > > > > >
> > > > > > > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > > > > > > news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > > > > > > > > > > In cell I8 I put a 1 or 2
> > > > > > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > > > > > If I put 2 then i want cell M7 to show �125 and cell
M8
> to
> > > > show
> > > > > > �125
> > > > > > > > > > >
> > > > > > > > > > > As a variation if its easier I would be happy with
cell
> I8
> > > > > > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > > > > > If I put 2 then i want cell M8 to show �100,   as
either
> > way
> > > > it
> > > > > > > would
> > > > > > > > > show
> > > > > > > > > > a
> > > > > > > > > > > total of �250
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > thanks
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
>
>

```
 0
ragdyer1 (4060)
7/6/2005 9:11:09 PM
```Nah, Harlan's a whiz kid.

--
Don Guillett
SalesAid Software
donaldb@281.com
"RagDyer" <RagDyer@cutoutmsn.com> wrote in message
news:eIRUC9mgFHA.2852@TK2MSFTNGP15.phx.gbl...
> Wouldn't it knock your socks off if Harlan chimed in and said he was only
> Jack Benny's age?
>
> Only us "old" folks know what that was.<vbg>
> --
> Regards,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
>
> "Sandy Mann" <sandymann2@mailinator.com> wrote in message
> news:eTUaoymgFHA.3852@TK2MSFTNGP10.phx.gbl...
> > Well, I'm just a youngster at 63......
> >
> > --
> >
> > Sandy
> > sandymann@mailinator.com
> > Replace@mailinator with @tiscali.co.uk
> >
> >
> > "CLR" <croberts@tampabay.rr.com> wrote in message
> > news:uio7GdmgFHA.3868@TK2MSFTNGP14.phx.gbl...
> > > .........and your point is?............<VBG>
> > >
> > > Vaya con Dios,
> > > Chuck, CABGx3
> > >
> > >
> > >
> > > "Sandy Mann" <sandymann2@mailinator.com> wrote in message
> > > news:OJq7HFmgFHA.2548@TK2MSFTNGP10.phx.gbl...
> > > > And I thought that I was associating with a bunch of whiz kids! <g>
> > > >
> > > > --
> > > >
> > > > Sandy
> > > > sandymann@mailinator.com
> > > > Replace@mailinator with @tiscali.co.uk
> > > >
> > > >
> > > > "Don Guillett" <donaldb@281.com> wrote in message
> > > > news:#v2056bgFHA.2904@tk2msftngp13.phx.gbl...
> > > > > Beat you all at 69 (favorite number) on income tax day.
> > > > >
> > > > > --
> > > > > Don Guillett
> > > > > SalesAid Software
> > > > > donaldb@281.com
> > > > > "RagDyer" <RagDyer@cutoutmsn.com> wrote in message
> > > > > news:%234aAA8agFHA.2644@TK2MSFTNGP09.phx.gbl...
> > > > > > Well I'll be darned ... you are old!<g>
> > > > > >
> > > > > > I'm November of '38.
> > > > > >
> > > > > > AND, what they say IS TRUE.
> > > > > >
> > > > > > It's NOT how old you are, but how old you FEEL.
> > > > > >
> > > > > > Also, these groups help delay the Alzheimers, keeping the brain
> > > > > exercising.
> > > > > > --
> > > > > > Regards,
> > > > > >
> > > > > > RD
> > > > > >
> > > > >
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > > > -
> > > > > > Please keep all correspondence within the NewsGroup, so all may
> > > benefit
> > > > !
> > > > >
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > > > -
> > > > > >
> > > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > > news:eSckDfCgFHA.4032@TK2MSFTNGP10.phx.gbl...
> > > > > > > I hear ya Scudo...........I'll turn 67 in September.  I had
done
> a
> > > > > little
> > > > > > > Symphony stuff before, but never really started into this
stuff
> > > strong
> > > > > > until
> > > > > > > after my Triple Bypass.......and I figured at that point,
"what
> > the
> > > > > > > he**".........give it a go, and it's been loads of fun.  I
tell
> > you
> > > > tho,
> > > > > > > like most things, I really have to keep after it all the time
or
> > it
> > > > gets
> > > > > > > away from me.....but I''ll tell you one thing, I do learn
> > something
> > > > new
> > > > > > > every day here, and really enjoy the experience of both
learning
> > > > > something
> > > > > > > myself, and helping other people where I can.........keep
coming
> > > back
> > > > > > Scudo,
> > > > > > > keep reading the newsgroup and you'll soon be
> > > responding..........you
> > > > > got
> > > > > > > the bug.......
> > > > > > >
> > > > > > > Vaya con Dios,
> > > > > > > Chuck, CABGx3
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > > news:3oZxe.67633\$Vo6.36687@fe3.news.blueyonder.co.uk...
> > > > > > > > Thanks CLR I have printed your reply and gonna spend some
time
> > > > trying
> > > > > to
> > > > > > > > understand and play with it,  It used to be easier when I
was
> a
> > > lot
> > > > > > > younger
> > > > > > > > now its enjoyable but frustrating, I love doing spreadsheet
> > stuff
> > > > but
> > > > > > the
> > > > > > > > brain aint what it used to be..ooooo to be young again. :-)
> > > > > > > >
> > > > > > > >
> > > > > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > > > > news:eILbBl#fFHA.2444@tk2msftngp13.phx.gbl...
> > > > > > > > > You're welcome Scudo.................
> > > > > > > > > My formulas were just basic IF statements,
> > > > > > > =IF(I8=1,150,IF(I8=2,125,""))
> > > > > > > > in
> > > > > > > > > M7 .....(IF I8 equals 1, then return 150, otherwise, IF I8
> > > equals
> > > > > 2,
> > > > > > > then
> > > > > > > > > return 125 otherwise leave the cell blank.)
> > > > > > > > >
> > > > > > > > > and =IF(I8=2,125,"") in M8.....(IF I8 equals 2, then
return
> > 125,
> > > > > > > otherwise
> > > > > > > > > leave the cell blank)........
> > > > > > > > >
> > > > > > > > > Both were then wrapped in TEXT statements to display the
> > > > > POUND
> > > > > > > > > sign..."CHAR(163)".
> > > > > > > > >
> > > > > > > > > If you wanted to do further math with the now TEXT
results,
> > you
> > > > > could
> > > > > > > > strip
> > > > > > > > > out the number part to multiply the result by 2
> > with...........
> > > > > > > > > =MID(M7,FIND(CHAR(163),M7,1)+1,99)*2...which says, in M7,
> find
> > > the
> > > > > > > > POUNDsign
> > > > > > > > > and go to the back side of it " the +1", and take the next
> 99
> > > > > > characters
> > > > > > > > and
> > > > > > > > > multiply by 2.....of course there's only 3 more characters
> so
> > it
> > > > > takes
> > > > > > > > them
> > > > > > > > > all.
> > > > > > > > >
> > > > > > > > > And you can put the POUND sign back in with
> > > CONCATENATION.........
> > > > > > > > >
> > > > > > > > > =CHAR(163)&MID(M7,FIND(CHAR(163),M7,1)+1,99)*2
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Vaya con Dios,
> > > > > > > > > Chuck, CABGx3
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > > > > news:PDFxe.335\$vF2.40@fe1.news.blueyonder.co.uk...
> > > > > > > > > > Chuck and RD
> > > > > > > > > >
> > > > > > > > > > Clever! `It works` and for the life of me I can`t
> (couldn`t
> > > ever
> > > > > > > never,
> > > > > > > > > old
> > > > > > > > > > time! or  new time!) understand either of them.  I look
at
> > the
> > > > > > > formulas
> > > > > > > > > and
> > > > > > > > > > try and work out how they work. I don`t know what they
> feed
> > > you
> > > > > guys
> > > > > > > on
> > > > > > > > > but
> > > > > > > > > > it sure seems to work, keep eating the stuff :-)
> > > > > > > > > >
> > > > > > > > > > and thanks for your help
> > > > > > > > > > really do appreciate it.
> > > > > > > > > >
> > > > > > > > > > Scudo
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > "CLR" <croberts@tampabay.rr.com> wrote in message
> > > > > > > > > > news:#8lVRk1fFHA.2152@TK2MSFTNGP14.phx.gbl...
> > > > > > > > > > > That's very clever RD........I've never seen it done
> like
> > > > that.
> > > > > > > > > > >
> > > > > > > > > > > I would have just used the old time
> > > > > > > > > > > =TEXT(IF(I8=1,150,IF(I8=2,125,"")),CHAR(163)&"000") in
> M7
> > > > > > > > > > > and =TEXT(IF(I8=2,125,""),CHAR(163)&"000") in M8.
> > > > > > > > > > >
> > > > > > > > > > > Vaya con Dios,
> > > > > > > > > > > Chuck, CABGx3
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > > > > > > > > > > news:ehtO7LzfFHA.3164@TK2MSFTNGP15.phx.gbl...
> > > > > > > > > > > > Try this:
> > > > > > > > > > > >
> > > > > > > > > > > > In M7:
> > > > > > > > > > > > =(I8=1)*150+125*(I8=2)
> > > > > > > > > > > >
> > > > > > > > > > > > In M8:
> > > > > > > > > > > > =125*(I8=2)
> > > > > > > > > > > > --
> > > > > > > > > > > >
> > > > > > > > > > > > HTH,
> > > > > > > > > > > >
> > > > > > > > > > > > RD
> > > > > > > > > > > > ==============================================
> > > > > > > > > > > > Please keep all correspondence within the Group, so
> all
> > > may
> > > > > > > benefit!
> > > > > > > > > > > > ==============================================
> > > > > > > > > > > >
> > > > > > > > > > > > "Scudo" <me@nospam.fictional> wrote in message
> > > > > > > > > > > >
news:fHAxe.24911\$G2.1051@fe1.news.blueyonder.co.uk...
> > > > > > > > > > > > In cell I8 I put a 1 or 2
> > > > > > > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > > > > > > If I put 2 then i want cell M7 to show �125 and cell
> M8
> > to
> > > > > show
> > > > > > > �125
> > > > > > > > > > > >
> > > > > > > > > > > > As a variation if its easier I would be happy with
> cell
> > I8
> > > > > > > > > > > > If I put 1 then I want cell M7 tp show �150
> > > > > > > > > > > > If I put 2 then i want cell M8 to show �100,   as
> either
> > > way
> > > > > it
> > > > > > > > would
> > > > > > > > > > show
> > > > > > > > > > > a
> > > > > > > > > > > > total of �250
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > thanks
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
> >
>

```
 0
Don
7/6/2005 9:46:49 PM

Similar Artilces:

Help on subscript out of range error (VB6/VBA)
Hi, I want to work with multiple excel workbooks en worksheets using a stand alone VB6 application. 1. First I open and close the workbooks and populate a listbox with sheetnames. 2. Then I select some sheets and fill an Array. (This array contains sheetnames from different workbooks) 3. The last step is to open and close the workbooks again and loop (For Each) through the sheets to get the information I need using the above mentioned array. The only problem is that I receive an "Subscript out of Range" error. This error occurs because I'm attempting tot access a workshee...

HELP! **Transfer orders to invoices error
I need some serious help. We just upgraded from GP 7.5 to GP 8.0 and now I am unable to transfer orders to invoices. I keep getting an error that says "Order ORD1555 has no line items to transfer to Invoice INV144408." Order# 1555 does have about 10 line items, which I can view on the screen. I did go in and run the "Check Links" function, but it hasn't done anything. This is our busiest time of year and a really bad time for something like this to happen. Can someone please give me some advice on how to fix this? if this is just one order, why not cancel...

Any Help documentation for Exchange 2007?
E2k7' help button gives 'Cannot display Help' Technical details: HC not found. (MS.OSSADMIN.manifest , 1033) Did I miss something? Not all the help is completed in the Beta 2 release. "Prem" <premmetje@zonnet.nl> wrote in message news:1161634519.758601.285030@i42g2000cwa.googlegroups.com... > E2k7' help button gives 'Cannot display Help' Technical details: HC not > found. (MS.OSSADMIN.manifest , 1033) > Did I miss something? > ...

Pls, help a beginner(MFC)
Could anybody tell me what is the future of MFC? I never used that library. I just got some skills in pure C++. But some knowledgeable people are saying it's not a good idea to study MFC, because "it's going to be obsolete" and replaced by .Net. They advise me to study C# because as they say "studying MFC will take you quite a lot of time by which Longhorn will be released and all coding will be done in managed way"... Well, I really don't know which direction to elect According to me :) MFC never be obsolete and it would be safe...

Help
My Regional Manager insists on things being perfect - need assistance with this problem. Working in Governemtn department - we have many users with unusal names and surnames - not common to standard dictionaries. My Rm wants to forward emails received with these peoples names in the original message - without outlook spell checking each of these names before sending. I have set up the email options under spelling - to ignore original message when forwarding - which it does but still spell checks the original message's recipients before sending. How do I set this up to exclude the n...

Distribution list help needed
We created a distribution list. Internal active directory users are able to send to the list. Internet e-mail senders are not able to send to the list. The mail is not bouncing back to the Internet e-mail users. The messages are just not getting to the inbox of the members of the distribution list. For example our domain is abc.net. The list we created is questions@abc.net. We have four users in the list. When a user logged into our Active Directory sends a mail to questions@abc.net the mail is successfully sent to the inboxes of all of the users in the list. When the e-mail ...

.pst file is maxed out - HELP
Apparently I have reached the maximum size of my outlook.pst file (see attached error message). I have tried deleting items but nothing I do seems to have any effect and I continue to get the attached error message. Therefore the eMail part of Outlook is disabled. Anyone got any pointers? XP Pro SP-2/Outlook 2003. Already using .pst format for database. Thanks, No image attached. Post a link, rather than an attachment. See http://www.slipstick.com/problems/repair2gbpst.htm=20 --=20 Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/o...

Fixing a formula
I have the following equation, it is looking up in another worksheet an pulling through information when it finds a match in second file fro cell d in first file. =VLOOKUP(D10,'C:\New Code Se up\[gcodenewsetupcopy.xls]Sheet1'!C4:O81,4,FALSE) This is working but when i copy the equation down a few rows th equation changes to this and it should still be looking at Sheet 1 C to O81. =VLOOKUP(D14,'C:\New Code Se up\[gcodenewsetupcopy.xls]Sheet1'!C8:O85,4,FALSE) I know i need to fix part of the equation but don't know how or whic bit. Please help -- Boethius -----------...

Replacing part of a formula
Currently I am working on a project that uses formulas to referenc another sheet in the workbook. I plan to use the newly created shee monthly. However I am in need of changing part of the cell formula. Example one cell says =Nov!D12 and I am needing to change it to rea =Dec!D12 or =Jan!D12 etc.... Any help -- Message posted from http://www.ExcelForum.com One way is to use the INDIRECT function when creating your formulas, eg:- Assuming your month was in say A3 then =INDIRECT(A3&"!A1") will give you the data from cell A1 on whatever sheet is listed in A3. Another option i...

Re: Can anyone help me with the IF function
Hello I'm trying to help my wife with simplifying her scheduling o employees. She uses 11 different time periods (1-11) some are worth the same amount of hours others are more or less. I can us seven functions to describe the period and the value of hours it is worth, but when I consolidate the functions i says the formula is invalid. I'm sure it can be fixed by one of you excel gurus! Here are the functions IF(B13<4,"7.75") IF(B13=4,"7.25") IF(B13=5,"6.25") IF(B13=6,"7.75") IF(B13=7,"6.75") IF(B13=8,"6.25") IF(B...

Help
Hi, i need to define a server side rule, which will copy attachments from received mails locally on PC/server. Any idea, scripts, anything? Tnx! Seems like ftp would be more appropriate than e-mail. But if you insist http://support.microsoft.com/search/default.aspx?spid=1773&query=event+sink+attachments&catalog=LCID%3D1033&pwt=false&title=false&kt=ALL&mdt=0&comm=1&ast=1&ast=2&ast=3&mode=a&x=18&y=11 HrVOjE wrote: > Hi, > > i need to define a server side rule, which will copy attachments from > received mails locally on PC/ser...

Active Directory Problem
Hi Everyone, Hopefully you can help me out a bit here. Long story short, we had a failure last week that we were unable to recover Active Directory from. As such, we've had to rebuild AD from scratch - now the domain name and all user accounts are recreated and identical to the previous setup. However, I can no longer access CRM. I assume CRM 4.0 is authenticating on, not only AD membership, but based on an AD GUID of some sort - which I can't replicate. How can I get back in to re-load my users? Thanks, Craig Hi, Did u check if the users were part of CRM groups created ...

Formula Help #23
If I have a number in cell A1 like 5 and another number in cell A3 like 6 I want the number in A7 to show -1 and if cell A3 was 4 to read +1 and if the numbers are 2 away from A1 then the numbers in cell A7 would be -2 or +2 depending on the number in cell A3. All help is appreciated. Thanks Karl You must be kidding! =A1-A3 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Karl" <Karl@discussions.microsoft.com> wrote in message news:21FB7D9E-DC79-42...

User forms #4
Rather than linking excel to a VB front end, how powerful are the VB userforms? If I want to create a front end of my excel workbook with sheets which will just display information that the cells calculate th how hard would this be? I also want to try and hide the fact that it is an excel spreadsheet? Thanks in advance Padrai -- Message posted from http://www.ExcelForum.com Shouldn't be too hard, especially if you know VB! To hide the fact the file is in excel you can do things such as hidin worksheets and also hiding toolbars when the worbook_open event i triggered. This can al...

Hi, In my spreadsheet cell E14 adds up E2 - E14 and cell C14 adds up C2 - C14. In G14 I have put a formula to show the difference between E14 and C14 as a Percentage ( formula for G14 is =SUM(E14-C14)/ABS(E14) ). When the Formula for G14 looks at E14 and C14 all it sees is a SUM formula to add up the column. Does anyone know how to solve this problem. Many thanks for looking. Rick Not sure I understand the problem; tell us what answer or error you ar getting. Also, don't you mean you are summing C2:C*13* in C14 and E2:E*13* i E14? Oh, and you can get rid of the Sum - this ...

Help Wanted...
I am looking to fill an entry level position within our company. We are a managed services provider in Dallas and have an immediate need for an entry level technician. If you know anyone who has some basic technical knowledge or aptitude and a willingness to learn, please forward this posting to them. I am primarily looking for someone who is capable and willing to learn more so than someone who has a lot of training and/or experience. This is an entry level position, but there will be a lot of opportunity for training and advancement. This position is full-time (contract to hire) and is avail...

I need help with My IF Statement....
I'm a college student and we are doing an assignment. I made it all th way to the end without any problems and now I'm stuck. The part I' stuck on involves using an IF Statement to determine whether or not bonus should be applied based on sales made. This will make much mor sense once you look at my workbook. I've got everything setup I jus need some help on where to put my numbers and formulas. If you think you can help me, reply to this thread or email me a ashbyb14@gmail.com. I can email you my workbook and instructions of what I'm suppose to d. Thank -- ash...

Using a txt string in formulae
Right this is an anoying little beggar but probably simple and im failing to see the wood from the trees so to speak ! right i have a workbook with multiple sheets and a front sheet the front sheet reports results of counts from the other sheets using =COUNT(sheet1!A:A) and =COUNTIF(Sheet1E:E,"Neg room") and other similair formula my question is this In column A i have the name of the sheet so I.E. A1=sheet1 which hyperlinks to the named sheet and columb B has the first formulae and so on and so on! my question is is there a way i can add the Word name of the sheet the Count form...

HELP!! Repeating Text over multiple Pages
I created a template containing a title, picture, map, and text box. The text box in particular contains information pertaining to a specific location. I created a 131 individual files using that template and everything came out looking great (thanks Microsoft). I had to create 131 individuals files because we needed to have it backed up for our server at work. The problem I am having now is when I attempted to combine each of 131 files by copying and pasting them into 1 publisher file containing 131 pages. The title, picture and map all preserve their own information. HOWEVER, the in...

comment boxes #4
I would like to change the default setting for comments. e.g. I want the default setting to always be "move but don't size with cells" rather than "don't move ...". I can change it for an individual comment, but I cannot find a way to apply t to all comments. I don't think you can change the default nor change existing comments easily through the UI. Here's a macro that will do it however: Sub AllCommentsMoveNoSize() Dim shp As Shape For Each shp In ActiveSheet.Shapes If shp.Type = msoComment Then shp.Placement = xlMove ...

Formula Help #31
I have 12 columns in a spreadsheet. One for every month of the year. As each month is completed the data for that month goes in that column. I need a fromula in a specific cell that will return the value of the most recent column (month) that is filled in. So in July it returns the data for July but will return the data for August when a value is placed in that cell. Any suggestions? Thank you. Steve Hubbard Steve, To return the right-most value from row 2 (Assuming your data start starts in column A and extends to the right) use the array formula (entered with Ctrl-Shift-Enter): =IND...

Help! w/ Outlook 2000