Formula for

Hi.

I want a formula to enter into a cell - if A1 is "M" then I want C1 to be
£8.00 or
if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I can
enter in Cell C1 to make display either £2.00 or £8.00 depending on wat is in
A1 -

Thanks for any help

Andy JL

Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,""))
If A1 is not M,C or V you get a blank
Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,0))
If A1 is not M,C or V you get a zero
Not case sensitive
best wishes
Bernard

"Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
news:703C0DD7-3FE6-49B1-AB64-F8515C613698@microsoft.com...
> Hi.
>
> I want a formula to enter into a cell - if A1 is "M" then I want C1 to be
> £8.00 or
> if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I
> can
> enter in Cell C1 to make display either £2.00 or £8.00 depending on wat is
> in
> A1 -
>
> Thanks for any help
>
> Andy JL

Bernard,
To your formula below I want to add if A1=D then it = the word "DAY", I have
been trying allways but can not get it to enter the word"DAY" even if i cut
the formula down to If (A1="D",DAY ....... I can do it with a number instead
of the "DAY" but I can not put it in to you formula. I think I have
expalinded myself!!!

Thanbk you

Andy JL

"bernard liengme" wrote:

> Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,""))
> If A1 is not M,C or V you get a blank
> Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,0))
> If A1 is not M,C or V you get a zero
> Not case sensitive
> best wishes
> Bernard
>
> "Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
> news:703C0DD7-3FE6-49B1-AB64-F8515C613698@microsoft.com...
> > Hi.
> >
> > I want a formula to enter into a cell - if A1 is "M" then I want C1 to be
> > £8.00 or
> > if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I
> > can
> > enter in Cell C1 to make display either £2.00 or £8.00 depending on wat is
> > in
> > A1 -
> >
> > Thanks for any help
> >
> > Andy JL
>
>
>

Put " marks around DAY

If (A1="D","DAY", <whatever>)

Adam

"Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
news:921DD082-B549-4A65-811B-6157278A60F3@microsoft.com...
> Bernard,
> To your formula below I want to add if A1=D then it = the word "DAY", I
> have
> been trying allways but can not get it to enter the word"DAY" even if i
> cut
> the formula down to If (A1="D",DAY ....... I can do it with a number
> instead
> of the "DAY" but I can not put it in to you formula. I think I have
> expalinded myself!!!
>
> Thanbk you
>
> Andy JL
>
> "bernard liengme" wrote:
>
>> Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,""))
>> If A1 is not M,C or V you get a blank
>> Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,0))
>> If A1 is not M,C or V you get a zero
>> Not case sensitive
>> best wishes
>> Bernard
>>
>> "Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
>> news:703C0DD7-3FE6-49B1-AB64-F8515C613698@microsoft.com...
>> > Hi.
>> >
>> > I want a formula to enter into a cell - if A1 is "M" then I want C1 to
>> > be
>> > £8.00 or
>> > if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I
>> > can
>> > enter in Cell C1 to make display either £2.00 or £8.00 depending on wat
>> > is
>> > in
>> > A1 -
>> >
>> > Thanks for any help
>> >
>> > Andy JL
>>
>>
>>

Adam,

Been trying most the afternoon without success , how do I Put -
IF(A1="D","DAY", into =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,""))

I'm getting a very sore head and the wall is not looking so good either!!!!!!!

Thank You

Andy JL

"Adam Kroger @hotmail.com>" wrote:

> Put " marks around DAY
>
> If (A1="D","DAY", <whatever>)
>
> Adam
>
> "Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
> news:921DD082-B549-4A65-811B-6157278A60F3@microsoft.com...
> > Bernard,
> > To your formula below I want to add if A1=D then it = the word "DAY", I
> > have
> > been trying allways but can not get it to enter the word"DAY" even if i
> > cut
> > the formula down to If (A1="D",DAY ....... I can do it with a number
> > instead
> > of the "DAY" but I can not put it in to you formula. I think I have
> > expalinded myself!!!
> >
> > Thanbk you
> >
> > Andy JL
> >
> > "bernard liengme" wrote:
> >
> >> Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,""))
> >> If A1 is not M,C or V you get a blank
> >> Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,0))
> >> If A1 is not M,C or V you get a zero
> >> Not case sensitive
> >> best wishes
> >> Bernard
> >>
> >> "Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
> >> news:703C0DD7-3FE6-49B1-AB64-F8515C613698@microsoft.com...
> >> > Hi.
> >> >
> >> > I want a formula to enter into a cell - if A1 is "M" then I want C1 to
> >> > be
> >> > £8.00 or
> >> > if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I
> >> > can
> >> > enter in Cell C1 to make display either £2.00 or £8.00 depending on wat
> >> > is
> >> > in
> >> > A1 -
> >> >
> >> > Thanks for any help
> >> >
> >> > Andy JL
> >>
> >>
> >>
>
>
>

Hi Andy

Try=IF(A1="D","DAY",IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"")))
I know a good plasterer!!!<bg>


Regards

Roger Govier


Andy JL wrote:
> Adam,
>
> Been trying most the afternoon without success , how do I Put -
> IF(A1="D","DAY", into =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,""))
>
> I'm getting a very sore head and the wall is not looking so good either!!!!!!!
>
> Thank You
>
> Andy JL
>
> "Adam Kroger @hotmail.com>" wrote:
>
>
>>Put " marks around DAY
>>
>>If (A1="D","DAY", <whatever>)
>>
>>Adam
>>
>>"Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
>>news:921DD082-B549-4A65-811B-6157278A60F3@microsoft.com...
>>
>>>Bernard,
>>>To your formula below I want to add if A1=D then it = the word "DAY", I
>>>have
>>>been trying allways but can not get it to enter the word"DAY" even if i
>>>cut
>>>the formula down to If (A1="D",DAY ....... I can do it with a number
>>>instead
>>>of the "DAY" but I can not put it in to you formula. I think I have
>>>expalinded myself!!!
>>>
>>>Thanbk you
>>>
>>>Andy JL
>>>
>>>"bernard liengme" wrote:
>>>
>>>
>>>>Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,""))
>>>>If A1 is not M,C or V you get a blank
>>>>Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,0))
>>>>If A1 is not M,C or V you get a zero
>>>>Not case sensitive
>>>>best wishes
>>>>Bernard
>>>>
>>>>"Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
>>>>news:703C0DD7-3FE6-49B1-AB64-F8515C613698@microsoft.com...
>>>>
>>>>>Hi.
>>>>>
>>>>>I want a formula to enter into a cell - if A1 is "M" then I want C1 to
>>>>>be
>>>>>£8.00 or
>>>>>if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I
>>>>>can
>>>>>enter in Cell C1 to make display either £2.00 or £8.00 depending on wat
>>>>>is
>>>>>in
>>>>>A1 -
>>>>>
>>>>>Thanks for any help
>>>>>
>>>>>Andy JL
>>>>
>>>>
>>>>
>>
>>

Try this:

C1: IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")

Also, if you aren't already, you might want to use Data Validation on Cell
A1 to only allow M,C, or V.

Does that help?

••••••••••
Regards,
Ron


"Andy JL" wrote:

> Hi.
>
> I want a formula to enter into a cell - if A1 is "M" then I want C1 to be
> £8.00 or
> if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I can
> enter in Cell C1 to make display either £2.00 or £8.00 depending on wat is in
> A1 -
>
> Thanks for any help
>
> Andy JL

Ron,

Thank you very much for that prompt reply- it works very well. Now how could
I quickly apply the same formula down the complete column - ie A1 to A15 for
example with the result going in the corresponding row in column C.1-15

Thank you again for your previous reply

Andy JL

"Ron Coderre" wrote:

> Try this:
>
> C1: IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")
>
> Also, if you aren't already, you might want to use Data Validation on Cell
> A1 to only allow M,C, or V.
>
> Does that help?
>
> ••••••••••
> Regards,
> Ron
>
>
> "Andy JL" wrote:
>
> > Hi.
> >
> > I want a formula to enter into a cell - if A1 is "M" then I want C1 to be
> > £8.00 or
> > if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I can
> > enter in Cell C1 to make display either £2.00 or £8.00 depending on wat is in
> > A1 -
> >
> > Thanks for any help
> >
> > Andy JL

If you copy IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")
down to C2 it will automatically change to
IF(A2="M",8,IF(OR(A2="C",A2="V"),2,"Invalid Entry")

does that answer question?
Bernard

"Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
news:077B25B7-AD21-4B8C-9063-C64271CB9ED0@microsoft.com...
> Ron,
>
> Thank you very much for that prompt reply- it works very well. Now how
> could
> I quickly apply the same formula down the complete column - ie A1 to A15
> for
> example with the result going in the corresponding row in column C.1-15
>
> Thank you again for your previous reply
>
> Andy JL
>
> "Ron Coderre" wrote:
>
>> Try this:
>>
>> C1: IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")
>>
>> Also, if you aren't already, you might want to use Data Validation on
>> Cell
>> A1 to only allow M,C, or V.
>>
>> Does that help?
>>
>> ..........
>> Regards,
>> Ron
>>
>>
>> "Andy JL" wrote:
>>
>> > Hi.
>> >
>> > I want a formula to enter into a cell - if A1 is "M" then I want C1 to
>> > be
>> > £8.00 or
>> > if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I
>> > can
>> > enter in Cell C1 to make display either £2.00 or £8.00 depending on wat
>> > is in
>> > A1 -
>> >
>> > Thanks for any help
>> >
>> > Andy JL

Bernard,
No, what I'm trying to do is apply the same formula that applies to row 1
down to row 15 for example -
I.e if A1 is M the C1 is 8
if A2 is M then C2 is * and so on.
I tried to copy and paste the formula from C1 to cell C2 but it did not
change.

Andy JL

"bernard liengme" wrote:

> If you copy IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")
> down to C2 it will automatically change to
> IF(A2="M",8,IF(OR(A2="C",A2="V"),2,"Invalid Entry")
>
> does that answer question?
> Bernard
>
> "Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
> news:077B25B7-AD21-4B8C-9063-C64271CB9ED0@microsoft.com...
> > Ron,
> >
> > Thank you very much for that prompt reply- it works very well. Now how
> > could
> > I quickly apply the same formula down the complete column - ie A1 to A15
> > for
> > example with the result going in the corresponding row in column C.1-15
> >
> > Thank you again for your previous reply
> >
> > Andy JL
> >
> > "Ron Coderre" wrote:
> >
> >> Try this:
> >>
> >> C1: IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")
> >>
> >> Also, if you aren't already, you might want to use Data Validation on
> >> Cell
> >> A1 to only allow M,C, or V.
> >>
> >> Does that help?
> >>
> >> ..........
> >> Regards,
> >> Ron
> >>
> >>
> >> "Andy JL" wrote:
> >>
> >> > Hi.
> >> >
> >> > I want a formula to enter into a cell - if A1 is "M" then I want C1 to
> >> > be
> >> > £8.00 or
> >> > if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I
> >> > can
> >> > enter in Cell C1 to make display either £2.00 or £8.00 depending on wat
> >> > is in
> >> > A1 -
> >> >
> >> > Thanks for any help
> >> >
> >> > Andy JL
>
>
>

Andy


I think Bernard is trying to get you to think for yourself here.

Select cell C1, move your cursor to the lower right of the cell.
it will become a black cross, left-click and drag down to cell C15.

The formulas should change to reflect the row number.

George Gee




Andy JL wrote:
> Bernard,
> No, what I'm trying to do is apply the same formula that applies to
> row 1 down to row 15 for example -
> I.e if A1 is M the C1 is 8
> if A2 is M then C2 is * and so on.
> I tried to copy and paste the formula from C1 to cell C2 but it did
> not change.
>
> Andy JL
>
> "bernard liengme" wrote:
>
>> If you copy IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")
>> down to C2 it will automatically change to
>> IF(A2="M",8,IF(OR(A2="C",A2="V"),2,"Invalid Entry")
>>
>> does that answer question?
>> Bernard
>>
>> "Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
>> news:077B25B7-AD21-4B8C-9063-C64271CB9ED0@microsoft.com...
>>> Ron,
>>>
>>> Thank you very much for that prompt reply- it works very well. Now
>>> how could
>>> I quickly apply the same formula down the complete column - ie A1
>>> to A15 for
>>> example with the result going in the corresponding row in column
>>> C.1-15
>>>
>>> Thank you again for your previous reply
>>>
>>> Andy JL
>>>
>>> "Ron Coderre" wrote:
>>>
>>>> Try this:
>>>>
>>>> C1: IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")
>>>>
>>>> Also, if you aren't already, you might want to use Data Validation
>>>> on Cell
>>>> A1 to only allow M,C, or V.
>>>>
>>>> Does that help?
>>>>
>>>> ..........
>>>> Regards,
>>>> Ron
>>>>
>>>>
>>>> "Andy JL" wrote:
>>>>
>>>>> Hi.
>>>>>
>>>>> I want a formula to enter into a cell - if A1 is "M" then I want
>>>>> C1 to be
>>>>> £8.00 or
>>>>> if A1 is "C or V" then I want C1 to be £2.00. Is there a formula
>>>>> that I can
>>>>> enter in Cell C1 to make display either £2.00 or £8.00 depending
>>>>> on wat is in
>>>>> A1 -
>>>>>
>>>>> Thanks for any help
>>>>>
>>>>> Andy JL

Andy

Ron's formula contains a couple of errors.
It should be:
=IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry"))

Must begin with an equals sign, and note the extra bracket on the end.

Try that in cell C1, and copy down to cell C15 as I have just posted.

George Gee


Andy JL wrote:
> Bernard,
> No, what I'm trying to do is apply the same formula that applies to
> row 1 down to row 15 for example -
> I.e if A1 is M the C1 is 8
> if A2 is M then C2 is * and so on.
> I tried to copy and paste the formula from C1 to cell C2 but it did
> not change.
>
> Andy JL
>
> "bernard liengme" wrote:
>
>> If you copy IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")
>> down to C2 it will automatically change to
>> IF(A2="M",8,IF(OR(A2="C",A2="V"),2,"Invalid Entry")
>>
>> does that answer question?
>> Bernard
>>
>> "Andy JL" <AndyJL@discussions.microsoft.com> wrote in message
>> news:077B25B7-AD21-4B8C-9063-C64271CB9ED0@microsoft.com...
>>> Ron,
>>>
>>> Thank you very much for that prompt reply- it works very well. Now
>>> how could
>>> I quickly apply the same formula down the complete column - ie A1
>>> to A15 for
>>> example with the result going in the corresponding row in column
>>> C.1-15
>>>
>>> Thank you again for your previous reply
>>>
>>> Andy JL
>>>
>>> "Ron Coderre" wrote:
>>>
>>>> Try this:
>>>>
>>>> C1: IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")
>>>>
>>>> Also, if you aren't already, you might want to use Data Validation
>>>> on Cell
>>>> A1 to only allow M,C, or V.
>>>>
>>>> Does that help?
>>>>
>>>> ..........
>>>> Regards,
>>>> Ron
>>>>
>>>>
>>>> "Andy JL" wrote:
>>>>
>>>>> Hi.
>>>>>
>>>>> I want a formula to enter into a cell - if A1 is "M" then I want
>>>>> C1 to be
>>>>> £8.00 or
>>>>> if A1 is "C or V" then I want C1 to be £2.00. Is there a formula
>>>>> that I can
>>>>> enter in Cell C1 to make display either £2.00 or £8.00 depending
>>>>> on wat is in
>>>>> A1 -
>>>>>
>>>>> Thanks for any help
>>>>>
>>>>> Andy JL