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