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