Nah, Harlan's a whiz kid.

--
Don Guillett
SalesAid Software

"RagDyer" wrote in message
...
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" wrote in message
...
Well, I'm just a youngster at 63......

--

Sandy

Replace@mailinator with @tiscali.co.uk


"CLR" wrote in message
...
.........and your point is?............<VBG

Vaya con Dios,
Chuck, CABGx3



"Sandy Mann" wrote in message
...
And I thought that I was associating with a bunch of whiz kids! <g

--

Sandy

Replace@mailinator with @tiscali.co.uk


"Don Guillett" wrote in message
...
Beat you all at 69 (favorite number) on income tax day.

--
Don Guillett
SalesAid Software

"RagDyer" wrote in message
...
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" wrote in message
...
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" wrote in message
. 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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message

...
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