help with formula

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

Have a look in HELP index for

IF

--
Don Guillett
SalesAid Software

"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

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

That worked RD

thanks

"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

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

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

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

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

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

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