Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
|
#13
|
|||
|
|||
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 |
#14
|
|||
|
|||
..........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 |
#15
|
|||
|
|||
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 |
#16
|
|||
|
|||
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 |
#17
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |