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