help with formula

[Don Guillett]

Have a look in HELP index for

IF

--
Don Guillett
SalesAid Software
[email protected]
"Scudo" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[RagDyeR]

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" <[email protected]> wrote in message
news:[email protected]...
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

[Scudo]

That worked RD

thanks

"RagDyeR" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> 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
>
>
>

[Scudo]

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

[CLR]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> 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
>
>
>

[Scudo]

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" <[email protected]> wrote in message
news:#[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > 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
> >
> >
> >
>
>

[Ragdyer]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:#[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > 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
> > >
> > >
> > >
> >
> >
>
>

[CLR]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:#[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > 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
> > >
> > >
> > >
> >
> >
>
>

[Scudo]

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" <[email protected]> wrote in message
news:eILbBl#[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:#[email protected]...
> > > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > 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
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

[CLR]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:eILbBl#[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> > > news:#[email protected]...
> > > > 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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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" <[email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > 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
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

[RagDyer]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:eILbBl#[email protected]...
> > > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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" <[email protected]> wrote in message
> > > > news:#[email protected]...
> > > > > 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" <[email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > 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" <[email protected]> wrote in message
> > > > > > news:[email protected]...
> > > > > > 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
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

[Don Guillett]

Beat you all at 69 (favorite number) on income tax day.

--
Don Guillett
SalesAid Software
[email protected]
"RagDyer" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> > > news:eILbBl#[email protected]...
> > > > 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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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" <[email protected]> wrote in message
> > > > > news:#[email protected]...
> > > > > > 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" <[email protected]> wrote in message
> > > > > > news:[email protected]...
> > > > > > > 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" <[email protected]> wrote in message
> > > > > > > news:[email protected]...
> > > > > > > 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
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

[Sandy Mann]

And I thought that I was associating with a bunch of whiz kids! <g>

--

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk


"Don Guillett" <[email protected]> wrote in message
news:#[email protected]...
> Beat you all at 69 (favorite number) on income tax day.
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "RagDyer" <[email protected]> wrote in message
> news:%[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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" <[email protected]> wrote in message
> > > > news:eILbBl#[email protected]...
> > > > > 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" <[email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > 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" <[email protected]> wrote in message
> > > > > > news:#[email protected]...
> > > > > > > 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" <[email protected]> wrote in message
> > > > > > > news:[email protected]...
> > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > news:[email protected]...
> > > > > > > > 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
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
>
>

[CLR]

..........and your point is?............<VBG>

Vaya con Dios,
Chuck, CABGx3



"Sandy Mann" <[email protected]> wrote in message
news:[email protected]...
> And I thought that I was associating with a bunch of whiz kids! <g>
>
> --
>
> Sandy
> [email protected]
> Replace@mailinator with @tiscali.co.uk
>
>
> "Don Guillett" <[email protected]> wrote in message
> news:#[email protected]...
> > Beat you all at 69 (favorite number) on income tax day.
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "RagDyer" <[email protected]> wrote in message
> > news:%[email protected]...
> > > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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" <[email protected]> wrote in message
> > > > > news:eILbBl#[email protected]...
> > > > > > 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" <[email protected]> wrote in message
> > > > > > news:[email protected]...
> > > > > > > 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" <[email protected]> wrote in message
> > > > > > > news:#[email protected]...
> > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > news:[email protected]...
> > > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > > news:[email protected]...
> > > > > > > > > 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
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
>

[Sandy Mann]

Well, I'm just a youngster at 63......

--

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk


"CLR" <[email protected]> wrote in message
news:[email protected]...
> .........and your point is?............<VBG>
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Sandy Mann" <[email protected]> wrote in message
> news:[email protected]...
> > And I thought that I was associating with a bunch of whiz kids! <g>
> >
> > --
> >
> > Sandy
> > [email protected]
> > Replace@mailinator with @tiscali.co.uk
> >
> >
> > "Don Guillett" <[email protected]> wrote in message
> > news:#[email protected]...
> > > Beat you all at 69 (favorite number) on income tax day.
> > >
> > > --
> > > Don Guillett
> > > SalesAid Software
> > > [email protected]
> > > "RagDyer" <[email protected]> wrote in message
> > > news:%[email protected]...
> > > > 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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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" <[email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > 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" <[email protected]> wrote in message
> > > > > > news:eILbBl#[email protected]...
> > > > > > > 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" <[email protected]> wrote in message
> > > > > > > news:[email protected]...
> > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > news:#[email protected]...
> > > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > > news:[email protected]...
> > > > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > > > news:[email protected]...
> > > > > > > > > > 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
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> >
>
>

[RagDyer]

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" <[email protected]> wrote in message
news:[email protected]...
> Well, I'm just a youngster at 63......
>
> --
>
> Sandy
> [email protected]
> Replace@mailinator with @tiscali.co.uk
>
>
> "CLR" <[email protected]> wrote in message
> news:[email protected]...
> > .........and your point is?............<VBG>
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "Sandy Mann" <[email protected]> wrote in message
> > news:[email protected]...
> > > And I thought that I was associating with a bunch of whiz kids! <g>
> > >
> > > --
> > >
> > > Sandy
> > > [email protected]
> > > Replace@mailinator with @tiscali.co.uk
> > >
> > >
> > > "Don Guillett" <[email protected]> wrote in message
> > > news:#[email protected]...
> > > > Beat you all at 69 (favorite number) on income tax day.
> > > >
> > > > --
> > > > Don Guillett
> > > > SalesAid Software
> > > > [email protected]
> > > > "RagDyer" <[email protected]> wrote in message
> > > > news:%[email protected]...
> > > > > 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" <[email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > 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" <[email protected]> wrote in message
> > > > > > news:[email protected]...
> > > > > > > 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" <[email protected]> wrote in message
> > > > > > > news:eILbBl#[email protected]...
> > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > news:[email protected]...
> > > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > > news:#[email protected]...
> > > > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > > > news:[email protected]...
> > > > > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > > > > news:[email protected]...
> > > > > > > > > > > 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
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
>
>

[Don Guillett]

Nah, Harlan's a whiz kid.

--
Don Guillett
SalesAid Software
[email protected]
"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > Well, I'm just a youngster at 63......
> >
> > --
> >
> > Sandy
> > [email protected]
> > Replace@mailinator with @tiscali.co.uk
> >
> >
> > "CLR" <[email protected]> wrote in message
> > news:[email protected]...
> > > .........and your point is?............<VBG>
> > >
> > > Vaya con Dios,
> > > Chuck, CABGx3
> > >
> > >
> > >
> > > "Sandy Mann" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > And I thought that I was associating with a bunch of whiz kids! <g>
> > > >
> > > > --
> > > >
> > > > Sandy
> > > > [email protected]
> > > > Replace@mailinator with @tiscali.co.uk
> > > >
> > > >
> > > > "Don Guillett" <[email protected]> wrote in message
> > > > news:#[email protected]...
> > > > > Beat you all at 69 (favorite number) on income tax day.
> > > > >
> > > > > --
> > > > > Don Guillett
> > > > > SalesAid Software
> > > > > [email protected]
> > > > > "RagDyer" <[email protected]> wrote in message
> > > > > news:%[email protected]...
> > > > > > 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" <[email protected]> wrote in message
> > > > > > news:[email protected]...
> > > > > > > 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" <[email protected]> wrote in message
> > > > > > > news:[email protected]...
> > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > news:eILbBl#[email protected]...
> > > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > > news:[email protected]...
> > > > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > > > news:#[email protected]...
> > > > > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > > > > news:[email protected]...
> > > > > > > > > > > > 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" <[email protected]> wrote in message
> > > > > > > > > > > >
news:[email protected]...
> > > > > > > > > > > > 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
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
> >
>