Ron

No problem.

George Gee


Ron Coderre wrote:
Thanks for correcting that, George...
I inadvertently left off the first and last characters when
copy/pasting. I'll have to pay better attention. :\


***********
Regards,
Ron


"George Gee" wrote:

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