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